I need help with a countif statement. I have information like the following:

A B
X 1
Y 1
X 2
X 0

I need to count how many times X in column A is greater than zero in column B.

Countif can handle only one condition. For multiple conditions, use
Sumproduct, as in:

=sumproduct(--(a1:a5="X"),--(b1:b50))

Regards,
Fred.

"Matt" wrote in message
...
I need help with a countif statement. I have information like the
following:

A B
X 1
Y 1
X 2
X 0

I need to count how many times X in column A is greater than zero in
column B.

=sumproduct(--($A$2:$A$100="X"),--($B$2:$B$1000))

"Matt" wrote:

I need help with a countif statement. I have information like the following:

A B
X 1
Y 1
X 2
X 0

I need to count how many times X in column A is greater than zero in column B.

If you're using Excel 2007:

=COUNTIFS(A1:A4,"x",B1:B4,"0")

--
Biff
Microsoft Excel MVP


"Matt" wrote in message
...
I need help with a countif statement. I have information like the
following:

A B
X 1
Y 1
X 2
X 0

I need to count how many times X in column A is greater than zero in
column B.

Hi,

And here are two old school formulas:

=SUMPRODUCT((A2:A5="X")*(B2:B50))
=SUM((A2:A5="X")*(B2:B50)) this one array entered (Shift+Ctrl+Enter)

--
Thanks,
Shane Devenshire


"Matt" wrote:

I need help with a countif statement. I have information like the following:

A B
X 1
Y 1
X 2
X 0

I need to count how many times X in column A is greater than zero in column B.