COUNTIF formula Using 2 or more cells

[SarahN]

Hi,

I am just exploring more with Excel. I am going to paste the table in and
explain what I am trying to acheive.
A B
1 31/04/2010 (month of reporting, Displayed as April, 2010)
2
3 12/04/2010 Vocational Assessment
4 15/03/2010 Vocational Assessment
5 01/04/2010 Vocational Re-Education

I am trying to Count how many Vocational Assessment have the Date in the
month of April.

Does anyone know the best formula to use. I have used
=SUMPRODUCT((A3:A5="31/03/2010")*(B3:B4="Vocational Assessment"))

This does calculate and count them however this would count 3 as the formula
is counting them as if they are single. I need it to count if it includes
Date in April and Vocational Assessment.

I hope I am making sense. please if anyone can help it would be uch
appreciated.

Sarah

 

[Jacob Skaria]

Try the below


=SUMPRODUCT((TEXT(A3:A10,"mmmyyyy")="Apr2010")*
(B3:B10="Vocational Assessment"))

 

[SarahN]

Thankyou so much you are a star!! The formula worked perfectly and has saved
so much time.

STAR