I am using the COUNT function to determine the

  • Thread starter Thread starter Skip
  • Start date Start date
S

Skip

number of data entries in a row. The number of entries vary from
40-70. The starting point of
my range is constant, but the last entry changes, depending on the
number of entries.
Is there a way I can write the COUNT formula, so I do not have to
change the second part
of my range? Thanks for any help. Skip
 
Hi

Using CountA will count the number of non-empty cells in the range:

=COUNTA(A1:A100)

Regards,
Per
 
Back
Top