Adding cells in excel from diff. sheets [Closed]

Question

Ask a question Report Reply to this topic

Adding cells in excel from diff. sheets [Closed]

gizmo - Feb 2, 2009 at 10:31 AM - Latest reply: An1

- Oct 8, 2014 at 07:59 AM

Excel Ask a question Report Reply to this topic

Hello,

Is it possible to add cells from different sheets in a single workbook. If so what is the formula?

Thanks

4 replies

Accepted Answer

Report Respond to Tweedledum

Tweedledum 183 Posts Monday January 19, 2009Registration date April 2, 2009 Last seen - Feb 2, 2009 at 11:00 AM

+1

Helpful

3

You could use a macro or function itd be something like

ActiveSheet.Range("G5").CurrentRegion.Select
Selection.Copy
Sheets("Sheet7").Select
ActiveSheet.Paste

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

ActiveSheet.Range("G5").Select

This line would select the sheet
Sheets("Sheet7").Select

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

Was this answer helpful? Yes No

Report

gizmo - Feb 2, 2009 at 11:24 AM

Thank you

Report

Alivallo - Oct 2, 2009 at 05:45 PM

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)

Explanation:
=SUM(otherSheet!cellRange1:cellRange2)

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:
=SUM(SheetTwo!D24)+(SheetThree!D10)

Report

An1 - Oct 8, 2014 at 07:59 AM

good thanks