| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum accross worksheets using names
It is clear this is allowed and works:
=SUM(Sheet1:Sheet5!A1) As the formula suggests the cell A1 in each sheet from Sheet1 through Sheet5 is summed. This does not seem to work: =SUM(Sheet1:Sheet5!Name_Ref1) Where Name_Ref1 is a name of a cell defined in each worksheet. More broadly I want to sum a given cell accross worksheets but that cell is not be in the same position within each workseet. Any ideas/comments...? Thanks ShaunL |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum accross worksheets using names
How would Excel know how to locate these named ranges unless you tell it what
to look for? You may have to sum these, with comma separations. How many do you have? =SUM(Name_Ref1,Name_Ref2,Name_Ref3) Good luck, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "ShaunL" wrote: It is clear this is allowed and works: =SUM(Sheet1:Sheet5!A1) As the formula suggests the cell A1 in each sheet from Sheet1 through Sheet5 is summed. This does not seem to work: =SUM(Sheet1:Sheet5!Name_Ref1) Where Name_Ref1 is a name of a cell defined in each worksheet. More broadly I want to sum a given cell accross worksheets but that cell is not be in the same position within each workseet. Any ideas/comments...? Thanks ShaunL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i use the same cell name accross multiple tab names in a wo | Excel Discussion (Misc queries) | |||
| Linking Cells accross Workbooks using Column Names | Excel Discussion (Misc queries) | |||
| COUNTIF: unique names and values accross several columns. | Excel Worksheet Functions | |||
| Vlookup accross multiple worksheets | Excel Worksheet Functions | |||
| How can I populate text accross worksheets? | Excel Discussion (Misc queries) | |||
Linear Mode
