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!
|