var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Count rows and column
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?
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() ??