That worked perfectly. Can you tell me what the "N" stands for in the formula?
--
Thank you,
Ant


"Bob Umlas" wrote:

=SUMPRODUCT(N(A1:A100="OLD"),N(B1:B100="HAPPY"),N( C1:C100=1),N(D1:D100="BLACK"))


"Ant" wrote in message
...
Count of occurrences that appear in multiple columns. For example I have
5
columns that label a particular account as a "NEW" or "OLD", "HAPPY" or
"SAD", "1" or "2", and "RED" or "BLACK". Each account has one of the
labels
and I want to count how many are labeled as "OLD", "HAPPY", "1", and
"BLACK".

I can't get the "COUNTIF", "COUNT(IF..." formula's to work. Can someone
assist?
--
Thank you,
Ant