auto list size

[capgunkidd]

I have to input a list that includes blank values which must be counted
Currently I must manually calculate the values. I am aware of th
countblank function, but is there a way to have it automatically adjus
for the size of the inputted list? Thank

 

[Trevor Shuttleworth]

A very simple way would be to use the ROW function. Assuming you have a
header in row 1, if you put the following function in row 18, you'd get the
answer 16

=ROW()-2

It's not dependent on the column and it simply counts the row between the
header and the row where the formula sits. It will also self adjust if you
add rows anywhere before the formula. You'll need to adjust the formula if
you have more than one header row.

Regards

Trevor