View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default How do I get a count of number of cells filled in?

Try one of these:

=COUNTA(C7:AO7)

This will count all *non-empty* cells. This includes formula blanks.

If you only want the count of cells that actually display something:

=SUMPRODUCT(--(LEN(C7:AO7)0))

This will not count formula blanks.

Biff

"Meenie" wrote in message
...
Ok, I think this might be easier than some of my other questions :)
What I want is a count of the number of cells in one row that are actually
used. So any blank ones will not be counted.
For example,
If I'm using cells C7 - AO7 but only C7 - AB7 are actually used, I want
that number. What formula would I use.
I know this is probably Kindergarten, but I don't know how to do it.
Thanks!