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

=sum(sheet1:sheet10!A5)

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 http://excelhints.com/2008/12/08/summing-across-multiple-sheets/

 

Contact Us

Learn Excel Tricks
Email: info@learnexceltricks.com