Range updates

  • Thread starter Thread starter nir020
  • Start date Start date
N

nir020

is it possible to create a formula so it adjust automically to number of row
or columns in a range, for example if there were values in the range C1 to C5
my countif formula would automatically adjust to countif(c1:c5) and if there
values in cells c1 to c1000 the formula would adjust to (c1:c1000)

Thanks
 
Back
Top