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

"Skip" skrev i meddelelsen
...
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