| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding up values from separate tabs
Hi,
I have 1 tab, called 'Annual stats',within which there are 9 cells which need formulas to add the values from the other 52 tabs (weeks). Each tab for the weeks are the same, so cell E30 is for example one cell which I need to be added. The tabs are labelled 'Week1' 'Week2' etc. What formula could i use? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding up values from separate tabs
Try this:
=SUM(Week1:Week52!E30) will add all the E30 cells on the sheets which are physically in between Week1 and Week52 tabs. Hope this helps. Pete On Mar 31, 3:02*pm, DaveAsh wrote: Hi, I have 1 tab, called 'Annual stats',within which there are 9 cells which need formulas to add the values from the other 52 tabs (weeks). Each tab for the weeks are the same, so cell E30 is for example one cell which I need to be added. The tabs are labelled 'Week1' 'Week2' etc. What formula could i use? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding up values from separate tabs
Hi,
Try this =SUM(Week1:Week52!A1) Which will sume A1 in all your sheets Mike "DaveAsh" wrote: Hi, I have 1 tab, called 'Annual stats',within which there are 9 cells which need formulas to add the values from the other 52 tabs (weeks). Each tab for the weeks are the same, so cell E30 is for example one cell which I need to be added. The tabs are labelled 'Week1' 'Week2' etc. What formula could i use? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| getting results on separate tabs | Excel Discussion (Misc queries) | |||
| Can you separate multiple tabs each into their own file | Excel Worksheet Functions | |||
| V lookup in separate TABS! | Excel Discussion (Misc queries) | |||
| Adding Values From Different Tabs | Excel Discussion (Misc queries) | |||
| Adding Values Based on a Separate Column | Excel Discussion (Misc queries) | |||
Hybrid Mode
