Multiple Sheets Sum


How to sum values from same cell address on different excel sheets?

Multiple Sheets Sum

In case, we have to sum values from same cell address ( from cell A5) across 10 excels sheets. The manual clicking of each cell to make a total of all ten sheets, is a complex approach. This method also reduce the readability of formula. The other available trick is quick and formula is easy to read. In the above given scenario,we can simply use this formula.

Sum Formula for multiple Sheets


Download: Sumformulaformultiplesheets

Note: We will use the name of the sheet . It can be sheet1 or Product A.

See the screen shots of  sum across multiple sheets at


Contact Us

Learn Excel Tricks