counting blanks in a list

  • Thread starter Thread starter capgunkidd
  • Start date Start date
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
 
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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a UDF to count blank cells 5
Counting blank cell issue 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
How activate "NUM" thingie? 10
count duplicats, display incremental count, restart count at changein value 2
Excel The logic hurts my head 5
Counting Occurrences 3
Count only cells with red font. 1

Back
Top