| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
Threaded Mode
