| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif or sumif with 2 criteria
How do I count the number of items per day per person?
Did a SUMIF but it counts all done on that day by all people. I want to count all done on that day by each person. Column A Date Column B person number eg 0706/05/ Column C no of items Date (number) Person (text) Items Answer 25/01/2007 0701/38/12 3 25/01/2007 0701/38/13 7 25/01/2007 0701/38/14 5 15 25/01/2007 0701/15/22 6 25/01/2007 0701/15/23 7 25/01/2007 0701/15/27 6 19 25/01/2007 0701/50/18 9 9 I'm looking for the 15 19 & 9 to appear in the Answer column Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif & Sumif with Multiple criteria | Excel Worksheet Functions | |||
| multiple criteria with countif or sumif | Excel Worksheet Functions | |||
| Multiple Criteria for COUNTIF and SUMIF | Excel Worksheet Functions | |||
| Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
| SUMIF/COUNTIF with an additional criteria | Excel Worksheet Functions | |||
Threaded Mode
