| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Function to sum same cell in several worksheets
Is there a function that will add the values of the same cell in several worksheets? Suppose I have 52 worskheets (one for each week in the year) and I want to add the values in cell D3 on each and place the result in another worksheet, is there a function that will save me having to type ='Sheet1'!D3+'Sheet2'!D3+'Sheet3'!D3+'Sheet4'!D3+' Sheet5'!D3+'Sheet6'!D3+'Sheet7'!D3 and so on? I tried =SUM('Sheet1'!D3:'Sheet52'!D3) but it looks as though the result is the sum of a block of cells spanning the 52 sheets. What I am after is something like =SUM('Sheet1'!:'Sheet52'!,D3). -- Stephen White ) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i copy a cell in worksheets 10 to the other 9 worksheets | New Users to Excel | |||
| Function THat wIll Add COntents Acorss Worksheets | Excel Worksheet Functions | |||
| Function to Return another Worksheets Name | Excel Worksheet Functions | |||
| VLOOKUP Function using multiple worksheets | Excel Discussion (Misc queries) | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Threaded Mode
