Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I SUMIF with two criteria in two different columns?
Good afternoon everyone. I have a task management table in which three of
the many columns indicate the week (Column "A") the work should be done, the person (Column "B") who should do it and the time (Column "C") it will take to get it done. I need to total each person's time based on who does it and in what week. In other words, I need the formula to sum the time only if the person (B)= X and the week (A)=Z. I have tried everything I can think of, but I just can't make it work. Any advice on this would be greatly appreciated. Thank you! Tina |
#2
|
|||
|
|||
Try
=sumproduct((b1:b100=x)*(a1:100=z)) Lance "Tina Winter" wrote: Good afternoon everyone. I have a task management table in which three of the many columns indicate the week (Column "A") the work should be done, the person (Column "B") who should do it and the time (Column "C") it will take to get it done. I need to total each person's time based on who does it and in what week. In other words, I need the formula to sum the time only if the person (B)= X and the week (A)=Z. I have tried everything I can think of, but I just can't make it work. Any advice on this would be greatly appreciated. Thank you! Tina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
sumif columns and rows | Excel Worksheet Functions | |||
SUMIF multiple criteria | Excel Worksheet Functions | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |