Try this for April and Citi.

=SUMPRODUCT((MONTH(A1:A4)=4)*(B1:B4="CITI"))

for may, change 4 to 5, june 6, july 7 and so on.


"Praveen kumar.M" <Praveen wrote in
message ...

Hi,

I have a sheet whit the following data:

DATE Subject
April 5, 2008 citi
April 5, 2008 citi
April 6, 2008 citi
April 4, 2008 bank
April 6, 2008 bank
May 5, 2008 citi
May 7, 2008 citi
May 5, 2008 bank
May 5, 2008 bank

*Note : DATE is formatted as '4-5-2008' to 'April 5, 2008'

Question:
I need to count number of rows for a particular month,
Ex:
For April : 5 and May : 4
And
For April : 3 for citi and 2 for bank and May : 2 for citi and 2 for bank

Please help me..

Thanks,
Praveen kumar.M