| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I imbed sheet names contained in cells into formulas?
I have a spreadsheet which contains a column with account numbers:
ACCT # 1 =SUMIF(SheetReference1,Cell,SheetReference1) 2 =SUMIF(SheetReference2,Cell,SheetReference2) 3 =SUMIF(SheetReference3,Cell,SheetReference3) 4 =SUMIF(SheetReference4,Cell,SheetReference4) These Account numbers are also the name of sheets. I need to use the SUMIF function to extract information from each sheet. However, when I copy paste the formula down I have to manually go into each cell and change the sheet reference. This can be quite annoying because the SUMIF function contains the sheet reference twice. If I could imbed the Account Number as a sheet reference I could save myself a lot of typing.... Does anyone have any suggestions or workarounds? -- Ted |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Formula to copy rng of cells where (value is met) to anther sheet | Excel Worksheet Functions | |||
| sorting master sheet messes up cells in other sheets linked to it | Excel Worksheet Functions | |||
| how get rid of cells with unused formulas | Excel Discussion (Misc queries) | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Threaded Mode
