SUMPRODUCT

I

Iriemon

I am trying to create a formula to count the number of text entries in that
match two criteria. This is as far as I have been able to go. Both fields are
text.

=SUMPRODUCT('Main'!A1:A1884<>"")*('Main'!C1:C1884="STHHH")
 
M

Max

Think you were just missing the outer parens:
=SUMPRODUCT((Main!A1:A1884<>"")*(Main!C1:C1884="STHHH"))
 
J

JE McGimpsey

Try:

=SUMPRODUCT(('Main'!A1:A1884<>"")*('Main'!C1:C1884="STHHH"))

or the somewhat more efficient

=SUMPRODUCT(--('Main'!A1:A1884<>""),--('Main'!C1:C1884="STHHH"))
 
I

Iriemon

DUH! What can I say, it's Friday and the brain is already on the weekend.

Thanks for the quick response.
 
M

Mike H

An extra pair of parenthesis should do it


=SUMPRODUCT((Main!A1:A1884<>"")*(Main!C1:C1884="STHHH"))

Mike

Mike
 
Top