# Total All entries

#### Jim Stewart

##### New Member
How do I total the records used or number of rows used on several worksheets? Also, can I get a total of the numbers in a column of another sheet.
Any help appreciated.

### Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

#### Erdinç E. Karaçam

##### Board Regular
Hi Jim,

Try this formulas;

Code:
``=SUM(Sheet1!A:A)+SUM(Sheet2!A:A)+SUM(Sheet3!A:A)+SUM(Sheet4!A:A)+SUM(Sheet5!A:A)+SUM(Sheet6!A:A)+SUM(Sheet7!A:A)+SUM(Sheet8!A:A)``

or;

Code:
``=SUM(Sheet1!A:A;Sheet2!A:A;Sheet3!A:A;Sheet4!A:A;Sheet5!A:A;Sheet6!A:A;Sheet7!A:A;Sheet8!A:A)``

#### timorrill

##### Well-known Member
In the cell that you want to sum to appear, use the following formula:

Code:
``=SUM(Sheet1!A:A,Sheet2!A:A,Sheet3!A:A,Sheet4!A:A,Sheet5!A:A,Sheet6!A:A,Sheet7!A:A,Sheet8!A:A)``

Update the names of the sheets / references as required.

#### Jim Stewart

##### New Member
I stated the problem wrong. How do I total the records or rows used?

#### stanleydgromjr

##### Banned

Try these:

How do I total all the entries in Column A on 8 worksheets?
=SUM(Sheet1!A:A,Sheet2!A:A,Sheet3!A:A,Sheet4!A:A,Sheet5!A:A,Sheet6!A:A,Sheet7!A:A,Sheet8!A:A)

Also, can I get a total of the numbers in a column of another sheet.
=COUNT(Sheet1!A:A)

I am using Windows XP Professional SP2, and Excel 2003 SP2.

Have a gret day,
Stan

#### Erdinç E. Karaçam

##### Board Regular
Code:
``=COUNTA(Sheet1!A:A;Sheet2!A:A;Sheet3!A:A;Sheet4!A:A;Sheet5!A:A;Sheet6!A:A;Sheet7!A:A;Sheet8!A:A)``

Or,

Code:
``=COUNTA(Sheet1!A:A)+COUNTA(Sheet2!A:A)+COUNTA(Sheet3!A:A)+COUNTA(Sheet4!A:A)+COUNTA(Sheet5!A:A)+COUNTA(Sheet6!A:A)+COUNTA(Sheet7!A:A)+COUNTA(Sheet8!A:A)``

Now?

#### Jim Stewart

##### New Member
Works great!Thanks to all

Not at all.

Replies
1
Views
43
Replies
18
Views
77
Replies
1
Views
128
Replies
0
Views
35
Replies
1
Views
131