Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Worksheet - Functions from sheet to sheet
can a function be placed in worksheet 2 that adds up numbers/data from
worksheet 1? |
#2
|
|||
|
|||
Yes, for instance
=SUM(Sheet1!A1:A18) will sum A1:A18 in Sheet1, the easiest way is to type =SUM( then just use the mouse to select the other sheet tab, then select the range also with the mouse and finish by pressing enter, then Excel will enclose the formula with a right parenthesis Regards, Peo Sjoblom "brietve" wrote: can a function be placed in worksheet 2 that adds up numbers/data from worksheet 1? |
#3
|
|||
|
|||
Sure
Simply co to your sheet enter = and then enter the function (I've used SUM) and click on the other sheet and highlight the cells you want to sum. =SUM(Sheet1!B7:F7) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "brietve" wrote in message ... can a function be placed in worksheet 2 that adds up numbers/data from worksheet 1? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
worksheet functions with dates | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |