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
|