Counting across worksheets

[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)?

 

[Paul Sheppard]

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 yo
will need to change the range A:A to be a column where there is data i
your worksheets, you will also need to extend the formula for all you
worksheets

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

Hope this helps

Pau

 

[Pelham]

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.