=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.