I would like to calculate a column based on selections from two other columns with drop down menus.
For example :
In one column, "C" you have 3 options (A team,B team,C team), In column "F" you have the day of week to schedule (Monday, Tuesday, Wednesday, Thursday, Friday) and in Column "E" I would like to put how many minutes total each line is.
This will calculate how many minutes worth A team has on Monday.
I have been successful using SUMIFS code to narrow by the first set of criteria
i.e. =SUMIFS(E2:E20,C2:C20,"A team")
When I try to add a second set of criteria, it doesn't work.
How can I achieve my goal here? Should I be trying something different?
I have tried just adding the criteria like so:
=SUMIFS(E2:E20,C2:C20,"A team",F2:F20,"Monday") ....... but it wont work!