Countif or sumif with 2 criteria
Try:-
=SUMPRODUCT((A1:A10=D1)*(B1:B10=D2)*(C1:C10))
whe-
D1 = the date you want
D2 = persons number
"chrisk" wrote:
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
|