Counting across worksheets

How can I get a total number of records within 23 different worksheets
without going through each worksheet adding up the number of rows
(records)?

Originally Posted by Pelham

How can I get a total number of records within 23 different worksheets
without going through each worksheet adding up the number of rows
(records)?

Hi pelham

Try this:

Insert an new worksheet in any cell eenter the following formula >

=COUNTA(Sheet1!A:A,Sheet2!A:A)

You will need to change sheet1/sheet2 to match your sheet names and you will need to change the range A:A to be a column where there is data in your worksheets, you will also need to extend the formula for all your worksheets

COUNTA counts all the rows that have an entry, so if there is a blank in the data it will not count it, if you want to count all the rows used irrespective of whether they contain data change COUNTA to COUNT

Hope this helps

Paul

Thanks Paul!

I have just seen that you can also use the =COUNTA function and
highlight all the worksheets (using Shift) and then click on one of the
column A's to identify the range.