On sheet 1 Column1 is a date function that returns the number of months sales
have come in, it is formatted as a number. On the same sheet in Column 2 I
want to sum the sales from another sheet ('PTD Comp Finney'!).

Sheet 1 Data
Column 1 Column 2
0 =IFERROR('PTD Comp Finney'!D16," ") - This is correct

1 =IFERROR('PTD Comp Finney'!D16," ") - If column 1=1, then I
want to calculate =IFERROR('PTD Comp Finney'!D1617," ")

2 =IFERROR('PTD Comp Finney'!D16," ")- If column 1=2, then I
want to calculate =IFERROR('PTD Comp Finney'!D1618," ")

3 =IFERROR('PTD Comp Finney'!D16," ")- If column 1=3, then I
want to calculate =IFERROR('PTD Comp Finney'!D1619," ")

4 =IFERROR('PTD Comp Finney'!D16," ")- If column 1=4, then I
want to calculate =IFERROR('PTD Comp Finney'!D1620," ")

5 =IFERROR('PTD Comp Finney'!D16," ")- If column 1=5, then I
want to calculate =IFERROR('PTD Comp Finney'!D1621," ")

and so on...

Any help would be most appreciated.
--
cheers,
Heather

Put this in B1
=IFERROR(SUM(INDIRECT("'PTD Comp Finney'!D16"&(16+A1))),"")

By putting appropriate number in A1 (0,1,2,...) you will get the answer you
want in B1

You can also copy this down and get different answers by putting different
numbers in Col A

"hcronrath" wrote:

> On sheet 1 Column1 is a date function that returns the number of months sales
> have come in, it is formatted as a number. On the same sheet in Column 2 I
> want to sum the sales from another sheet ('PTD Comp Finney'!).
>
> Sheet 1 Data
> Column 1 Column 2
> 0 =IFERROR('PTD Comp Finney'!D16," ") - This is correct
>
> 1 =IFERROR('PTD Comp Finney'!D16," ") - If column 1=1, then I
> want to calculate =IFERROR('PTD Comp Finney'!D1617," ")
>
> 2 =IFERROR('PTD Comp Finney'!D16," ")- If column 1=2, then I
> want to calculate =IFERROR('PTD Comp Finney'!D1618," ")
>
> 3 =IFERROR('PTD Comp Finney'!D16," ")- If column 1=3, then I
> want to calculate =IFERROR('PTD Comp Finney'!D1619," ")
>
> 4 =IFERROR('PTD Comp Finney'!D16," ")- If column 1=4, then I
> want to calculate =IFERROR('PTD Comp Finney'!D1620," ")
>
> 5 =IFERROR('PTD Comp Finney'!D16," ")- If column 1=5, then I
> want to calculate =IFERROR('PTD Comp Finney'!D1621," ")
>
> and so on...
>
> Any help would be most appreciated.
> --
> cheers,
> Heather

I think what you want to do is something like this:

=IFERROR(SUM(INDIRECT("'PTD Comp Finney'!D16"&16+A1)),"")

and then copy down.

Hope this helps.

Pete

On Feb 26, 7:35*pm, hcronrath <hcronr...@discussions.microsoft.com>
wrote:
> On sheet 1 Column1 is a date function that returns the number of months sales
> have come in, it is formatted as a number. *On the same sheet in Column2 I
> want to sum the sales from another sheet ('PTD Comp Finney'!).
>
> Sheet 1 Data
> Column 1 *Column 2
> 0 * * * * * * =IFERROR('PTD Comp Finney'!D16," ") - This iscorrect
>
> 1 * * * * * * =IFERROR('PTD Comp Finney'!D16," ") - If column 1=1, then I
> want to calculate *=IFERROR('PTD Comp Finney'!D1617," ")
>
> 2 * * * * * * =IFERROR('PTD Comp Finney'!D16," ")- If column 1=2, then I
> want to calculate *=IFERROR('PTD Comp Finney'!D1618," ")
>
> 3 * * * * * * =IFERROR('PTD Comp Finney'!D16," ")- If column 1=3, then I
> want to calculate *=IFERROR('PTD Comp Finney'!D1619," ")
>
> 4 * * * * * * =IFERROR('PTD Comp Finney'!D16," ")- If column 1=4, then I
> want to calculate *=IFERROR('PTD Comp Finney'!D1620," ")
>
> 5 * * * * * * =IFERROR('PTD Comp Finney'!D16," ")- If column 1=5, then I
> want to calculate *=IFERROR('PTD Comp Finney'!D1621," ")
>
> and so on...
>
> Any help would be most appreciated.
> --
> cheers,
> Heather