hi,

strange, it works here, could you type your formula?

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"JBurlage" escreveu:

Marcelo - I tried it and it does not work. I get a count of 0.

"Marcelo" wrote:

hi,

=sumproduct(--(a2:a1000="new")*(b2:B1000="critical"))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"JBurlage" escreveu:

Microsoft Excel 2000:
Is it possible to count values from two columns. I know that to count
values from one column the formula is =COUNTIF(B2:B20,"NEW"), but I need to
count a value from a second column also. For example:
Column A Column B
NEW critical
NEW critical
CLOSED major
NEW major

I need a formula that will count the value for "NEW" in Column A that are
"critical" in Column B. The count for this example should be 2. The count
for NEW - major should be 1 and CLOSED - major should be 1. Can anyone help?
THANKS!!