Allow relative referencing for imbedded sheetnames in formulas

[Ted]

Please share whether it is possible to somehow imbed sheet names contained in
a cell to allow for relative referencing in a formula...so autofill can be
used to fill in sheets....




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


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions

[Biff]

Hi!

What are the sheet names? Do they have a sequential pattern like the default
sheet names: Sheet1, Sheet2, Sheet3 etc.?

Biff

"Ted" <[email protected]> wrote in message
news:[email protected]...
> Please share whether it is possible to somehow imbed sheet names contained
> in
> a cell to allow for relative referencing in a formula...so autofill can be
> used to fill in sheets....
>
>
>
>
> 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
>
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...heet.functions