Ask a question Report

Adding cells in excel from diff. sheets

gizmo - Latest answer on Oct 8, 2014 07:59AM
Is it possible to add cells from different sheets in a single workbook. If so what is the formula?
Read more 

moins plus
You could use a macro or function itd be something like


Current range will select everything beside it so it might be closer to


This line would select the sheet

The destination would be something similer to the first line although a little different. I'm no excel guru or anything but that will get you on the right path
gizmo- Feb 2, 2009 11:24AM
Thank you
Alivallo- Oct 2, 2009 05:45PM
there is an easier method. using the GUI of Office 2007.

highlight the cell you want the 'total' to be in.

--->click on the 'E' sum button (usually on the 'home' ribbon, under the 'editing' section)

--->go to the other sheet, highlight the Cells you wish to Add/sum,

--->Press Enter.....your done. (do not navigate anywhere else before you press enter as this will change the formula)


Example formula:
=SUM(SheetTwo!D24:D26) this will add cells d24 through d26 on another sheet called: SheetTwo.

Example of adding cells from 2 different sheets:
An1- Oct 8, 2014 07:59AM
good thanks
Add comment
This document entitled « adding cells in excel from diff. sheets » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.

Not a member yet?

sign-up, it takes less than a minute and it's free!

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.