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