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.