Range updates

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CAN WE LOCK CELLS AT F COLUMN BASED ON VALUE AT C COLUMN 5
Datavalidation with shrinking non blank values 1
Code works on sheet but not from code-to-sheet 2
Copy range from one sheet to another cell by cell 2
Copy columns and paste with blank column between 5
multiple sumproducts and now formula is too long 3
Excel formula to count the number of records which contains a certaintext (wildcard) 3
using defined name in UDF 7

Top