count if it meets a certain condition

[daniels012]

I need to count the text "CEP"
if column E:E has "CEP" and Column F:F is January 2005.

What can I write to get that count?

Michael

 

[Oaktree]

=SUMPRODUCT(--(E2:E1000="CEP"),--(TEXT(F2:F1000,"mmmm yyyy") = "January 2005"))

 

[just_jon]

Book1
	E	F	G	H	I
1	Field1	Field2		CEP	1/1/2005
2	CEP	1/1/2005	12	92
3	XXX	1/1/2005	99
4	CEP	1/1/2005	53
5	CPE	1/1/2005	76
6	CEP	2/1/2005	18
7	CEP	1/1/2005	27
8
9
10
Sheet1

 

[daniels012]

Thank you very much, both of you. I have soooooo much to learn about SumProduct.

What do the "--" represent. Just trying to learn.

Michael

 

[just_jon]

Thank you very much, both of you. I have soooooo much to learn about SumProduct.

What do the "--" represent. Just trying to learn.

Michael

The -- acts as a coercer.

The argument

(--(E2:E10=H1)

will product an array of TRUE/FALSE's. These need to be switched, or coerced, into their numeric counterparts in order for the SUMPRODUCT function to use them for multiplication.

-- does this, as would either of

((E2:E10=H1)+0)
((E2:E10=H1)*1)

 

[daniels012]

Thank you

Michael