SUMPRODUCT

[Guest]

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")

 

[Guest]

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

 

[JE McGimpsey]

Try:

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

or the somewhat more efficient

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

 

[Guest]

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

Thanks for the quick response.

 

[Guest]

An extra pair of parenthesis should do it


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

Mike

Mike

 

[Max]

welcome. it happens to me too <g>.