Hi,

I have two columns with data. column B and column C.

I want to be able to count the number of rows where column B = 0 and column C <> 0
hhh.xlsx
In the attached example I want it to return 2. B6 = 0, C6 <> 0 ... B9 = 0, C6 <> 0

I figured out how to use the =CountIf function to count 0's in one column, then got stuck.

Thanks,
Nick