Home

Worksheet Building

Thopewood_1955-
Occasional Visitor

Hello,

 

I am trying to figure out how to have the totals on various worksheets in an excel workbook add up on a summary page.

 

Thank you!

1 Reply

Hello,

 

your question is a bit vague. You can add cells from different sheets in a few different ways, depending on how your data is structured.

 

For example, you can start a total by entering a = sign, then click the sheet and the cell with the first value that you want to include in the total, then type a + sign and click the sheet and the cell with the next value that you want to include in the total, etc., then hit Enter. The formula will look something like

 

=Sheet2!A1+'Another Sheet'!B4+LastSheet!R24

 

The sheet name is followed by an exclamation mark and then by the cell address. If a sheet name has spaces, it needs to be wrapped in single quotes.

 

Another scenario is where the values you want to sum up are in the same cell on all sheets. In that case, you can use a Sum function that spans all sheets, like

 

=SUM(Sheet2:Sheet4!B11)

 

Let me know if that helps.

 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies