View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Count cells in a range

Hi Otto,

Try the following. While it appears to be looking for not blank, for me
under testing that I have done it appears to count all cells whether they are
blank or not. However, I suggest that you test it under the circumstances
where you intend to use it.

There is a separate COUNTBLANK function and I suggest it is there because
the COUNTIF function fails trying to count blanks as a criteria.

I'll be interested if you find any circumstances where it does not work.

=COUNTIF(D1:G20,"<""")

--
Regards,

OssieMac