Search : in
By :

Adding cells in excel from diff. sheets

Last answer on Oct 2, 2009 10:45:50 pm BST gizmo, on Feb 2, 2009 3:31:30 pm GMT 
 Report this message to moderators

Hello,

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

Thanks

Configuration: Mac OS X
Safari 525.27.1

Best answers for « adding cells in excel from diff. sheets » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Download USA Unlisted Cell Phone Numbers ShowHas you friend flown for America without telling you where he/she would settle? Dont panic! USA Unlisted Cell Phone Numbers is a program which can help you. By using this program, you simply need to know his/her phone number in order to find...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

Tweedledum, on Feb 2, 2009 4:00:45 pm GMT
  • +1

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

   
Reply to Tweedledum

2

gizmo, on Feb 2, 2009 4:24:51 pm GMT

Thank you

   
Reply to gizmo

3

 Alivallo, on Oct 2, 2009 10:45:50 pm BST
  • +2

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)

   
Reply to Alivallo
Ask your question Reply
They need your help