Think you were just missing the outer parens:
=SUMPRODUCT((Main!A1:A1884<"")*(Main!C1:C1884="ST HHH"))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Iriemon" wrote:
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")