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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies