Hi All,

So I know how to do a countif but rather than using a range (eg: A20:A25) I want to do individual cells. (eg: A20,A21,A25,B25,C26) and count the amount of zeros.

I have tried using the offset function but have had little luck

=countif(range,criteria)

=countif((A20,A21,A25,B25,C26) ,"-")

=countif(cells(A20,A21,A25,B25,C26) ,"-")

hopefully this makes sense.

Cheers