SUMPRODUCT
 

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

SUMPRODUCT
 

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

SUMPRODUCT
 

Try:

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

or the somewhat more efficient

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

In article ,
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")

SUMPRODUCT
 

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

Thanks for the quick response.



"Max" wrote:

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

SUMPRODUCT
 

An extra pair of parenthesis should do it


=SUMPRODUCT((Main!A1:A1884<"")*(Main!C1:C1884="ST HHH"))

Mike

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

SUMPRODUCT
 

welcome. it happens to me too <g.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Iriemon" wrote in message
...
DUH! What can I say, it's Friday and the brain is already on the weekend.

Thanks for the quick response.