Reference Sheet Sum Range Formula

[Pinaceous]

Hi All,

I'm working with a cell formula, in trying to reference a rows sum from another worksheet's range.

For example, if I'm in SheetB working in cell A1 and I want to reference the sum of a range of D34:J34 in SheetA.

I thought it would look something like this but I'm getting an error:

='SheetA'!D34:J34

Can anyone lend a hand?

Many thanks!
pinaceous

 

[Pinaceous]

Oh wait, that would be

 =SUM('SheetA'!D31:J31

But how would you propose this one from multiple sheets?

  ='SheetA'!D31+'SheetB'!E31+'SheetC'!F31+'SheetD'!G31+'SheetE'!H31+'SheetF'!I31+'SheetG'!J31

???

 

[Peter_SSs]

But how would you propose this one from multiple sheets?

  ='SheetA'!D31+'SheetB'!E31+'SheetC'!F31+'SheetD'!G31+'SheetE'!H31+'SheetF'!I31+'SheetG'!J31

They are 7 different cell addresses on 7 different sheets, so what you have is how to do it.