If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Duplicating Excel's Autofilter functionality | rgrantz | Running & Setting Up Queries | 0 | November 3rd, 2004 11:06 PM |
SUMIF with 2 criteria | Christine | Worksheet Functions | 1 | February 25th, 2004 09:31 PM |