counting blanks in a list

C

capgunkidd

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
 
B

Bob Phillips

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)
 
C

capgunkidd

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
 
Top