=SUMPRODUCT(--(MONTH(A2:A20)=4),--(B2:B20="John"),--(C2:C20="Smith"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ElvisS" <[email protected]> wrote in message
news:[email protected]...
> 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
>