Adding Sums from one sheet to another and continue for several sheet

Hi Walbert,

Go to the sheet and the cell where you want get the sum (for example, in cell C5 to Sheet1). Type = and select the cell you want to add from this sheet (for example cell C7), then type + and select the next sheet you want to add, for example Sheet2 and go to the desired cell (for example, cell D9), type again + and click on the other sheet, for example Sheet8 and select the desired cell (for example cell B3) and so on. After you have added all the cells of the diferent sheets press Enter to get the result. The formula you created will have to look like this:

=SUM(Sheet1!C7+Sheet2!D9+....+Sheet8!B3+....)

But if data that you want to sum are the same cell of each page (eg in cell E10) then you can use this formula:

= SUM(Sheet1:Sheet12!E10)

To get to such a formula you will need to press = in the cell you want to get the result (for example in cell E15 to Sheet1) and after you have selected cell E10 hold down the SHIFT key and select Sheet12. Press ENTER.

For more you can see this page in internet: http://www.exceltip.com/summing/summing-values-from-cells-in-different-sheets.html or search in Google for Sum Across Multiple Sheets in Microsoft Excel.

Hope this helps,

IlirU

If my reply answer your question, then please mark it as Answer.

For a progressive total across 12 sheets I would suggest a User Defined Function.

Download the sample workbook Carry_Across_Sheets.xlsm from this site.

https://onedrive.live.com/?id=863B7DD7364138EC%21113&cid=863B7DD7364138EC

Gord