Excel 2007 : Sum Indirect Cells

[KeepCallmAndExcel]

Good Day,

This is more of a neatness question really,

I am trying to Sum two Indirect Cells (i'm using Indirect as I always have to add new lines on that sheet with up to date figures, absolute cell references wouldnt work in this instance)

I can do it messy, for example:

Cell A1 =INDIRECT("'2012'!D5")
Cell A2 =INDIRECT("'2012'!D3")
Cell A3 =SUM(A1,A2)

2012 is the sheet name as the sum is on a different sheet compared to where the data is.

However, When I try to add these two Indirect cells together I just cant get it to work.

I have tried:
=(INDIRECT("2012!D3")+("2012!D5"))
=SUM(INDIRECT(2012"!D3,D5"))
etc...

but I am a bit lost.

Does anyone have any suggestions?

[Richard Buttrey]

Hi,

=INDIRECT("'2012'!D5")+INDIRECT("'2012'!D3")

Seems to work for me. As does

=INDIRECT("'2012'!D"&5)+INDIRECT("'2012'!D"&3)

or

=SUM(INDIRECT("'2012'!D5:D3"))

[KeepCallmAndExcel]

That worked!!!

I just had too many "=" & "()()"

Thanks very much!