COUNTIF Multiple cells in column

Originally Posted by swaza

=COUNTIF(B18,B27,B28,B40,B48,"0*")

but this didn't work.

Something like this:

=SUM(COUNTIF(INDIRECT({"B18","B27","B28","B40","B48"}),"0*"))

But that's not very robust.

I think you need to post a SMALL sample file so we can see what you're trying to do.

We don't need a file with hundreds of rows and dozens of columns worth of data. About 20 rows and a few columns worth of data is plenty.

Make sure you tell us what results you expect.