Count cells in a column with certain criteria

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

Nick,

You can use the COUNTIFS function:

Please Login or Register  to view this content.

2 other solutions:

somproduct (see the example => the green cel)

filter in combination with subtotal (see the example => the gold cel)

Do you have questions, just ask.

And one extra => pivot table.

Much thanks,

Niko