| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate cells over multiple worksheets
You could use 'Named Range' to add them.
Select the F9 c ell in the 1st sheet and selectInsertNameDefine Call it F9Sheet1 Do the same for all sheets, changing only the Sheet 1 to 2 etc. On the Total WorkSheet, enter the Formula as'=F9Sheet1+F9Sheet2+F9Sheet3' Corey.... "mrsjoan" wrote in message ... I have 4 worksheets in one book. Worksheet names are July, August, September, Total. In cell F9 of each worksheet I have a dollar value I would like to add and place in a cell in a 4th worksheet. Example: July's F9 is $600; August's F9 is $200; September's F9 is $100. Now I want $900 to show in F9 of the worksheet Total. How do I do this. I am a novice so please break it down clearly. Your help will be greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i calculate the average of 30+ cells over multiple workshee | Excel Worksheet Functions | |||
| how to make a macro to clear multiple cells from multiple worksheets? | Excel Worksheet Functions | |||
| Calculate Average Accross Multiple Worksheets | Excel Discussion (Misc queries) | |||
| calculate rows across multiple worksheets | Excel Discussion (Misc queries) | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Threaded Mode
