Count cells in a column with certain criteria

Nick,

You can use the COUNTIFS function:

=COUNTIFS(B1:B9,0,C1:C9,"<>0")

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.