COUNTIF formula Using 2 or more cells
 

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

COUNTIF formula Using 2 or more cells
 

Try the below


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

--
Jacob (MVP - Excel)


"SarahN" wrote:

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

COUNTIF formula Using 2 or more cells
 

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

STAR

"Jacob Skaria" wrote:

Try the below


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

--
Jacob (MVP - Excel)


"SarahN" wrote:

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