countif on specific cells not a range.

**pavlos** · 10-08-2012, 08:16 PM

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

**bentleybob** · 10-08-2012, 09:34 PM

=sumproduct((a20=1)+(a21=1)+(a25=1)+(b25=1)+(c26=1))

**FDibbins** · 10-08-2012, 11:51 PM

2007 has an added count function called countifS() (also sumifS(), averageifs(). it adds more flexibility to counting. try using that and see if it gives you what you want?