counting blanks in a list
 

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 t
do it automatically. Thanks

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

counting blanks in a list
 

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/

counting blanks in a list
 

There is a COUNTBLANK() worksheet function

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

counting blanks in a list
 

I know about the countblank function but I need it to be able to handl
any size list, as the list size varies from day to day

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