Guess what?

=COUNTBLANK(A1:J1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"capgunkidd " wrote in message
...
I have a list the includes blank values which must also be counted.
Currently i am manually finding this total but i was wondering how to
do it automatically. Thanks.


---
Message posted from http://www.ExcelForum.com/