Pinaceous
Well-known Member
- Joined
- Jun 11, 2014
- Messages
- 1,113
- Office Version
- 365
- Platform
- Windows
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:
Can anyone lend a hand?
Many thanks!
pinaceous
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:
VBA Code:
='SheetA'!D34:J34
Can anyone lend a hand?
Many thanks!
pinaceous