Hey, can anybody help me? I would like to count how many rows and columns that has a value.

Example, Column A contains the data you want to count.
Now in column B put this formula:
=iif(A1 = "",0,1)
Apply all the way down the sheet and then sum at the bottom.

Not the prettiest method by any means but it works and I can't think of a better one right now

Howdy. What do you mean by "value"? Any character, number, non-numerical?

Hi

As shades pointed out, it can/will depend on what you define as a value, but COUNTA() and COUNTBLANK() functions may also be useful, perhaps with ISNUMBER() ??


MTB