function to find the total no. of rows to be used in a spreadsheet

Posted by Kev on February 14, 2001 11:35 AM

I need to set up a series of tables which will use data held on a seperate sheet as the source - id there a way of setting up a formula which will automatically know how many rows need to be used in the calculations?

Posted by Dave Hawley on February 14, 2001 12:08 PM

Hi Kev

Couldn't you just name the range ? and use it in your formulas. If you had a table range named MyRange you could get a row count by using:
=ROWS(MyRange)

You may also be interested in Dynamic Named Ranges if you click my link to my web page you will see a link that explains them, with examples.

Dave

OzGrid Business Applications