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.