try this one:
=COUNT(IF((date=A2:A20)*(B2:B20="John")*(C2:C20=" smith"),1))
change date to which date you want.
Example for April month:
=COUNT(IF((A2:A20=DATEVALUE("4/1/2006"))*(A2:A20<=DATEVALUE("4/30/2006"))*(B2:B20="john")*(C2:C20="smith"),1))
Note: this is Array function, so once you entered function to purticular
cell, press Ctrl+Shift+Enter key
"ElvisS" wrote:
Hi!
I have a sheet with 3 rows (A- date; B-first_name; C-last_name) - see
http://users.kiss.si/~k4ef2308/images/1.jpg for screenshot.
I would like to count a number of (for example) cells with values John
(in row B ) Smith (in row C) for a certain period, let's say April (row
A). I need a review for certain people and for certain period. See
http://users.kiss.si/~k4ef2308/images/2.jpg for screenshot.
How should I write formula?
Tnx, Elvis