How to reference multiple cells of other sheet w/out addressing sheet each and every time?

[juntjoo]

So I'm writing a lot of formulas that go back and forth between the sheet they're on to another sheet from cell to cell to make one formula like:

='other sheet'!A1+'other sheet'!B1

when I'd rather write it something like this:

='other sheet'!(A1+B1)

to save space, but apparently you can't. What's the next best method if there is anything?

[Pete_UK]

You could set up named ranges for the cells in the other sheet, and then you could write:

=name1 + name2

Hope this helps.

Pete

[TMS]

For that specific example:

='Other Sheet'!A1+'Other Sheet'!B1

Could be:
=SUM('Other Sheet'!A1:B1)

[juntjoo]

Thanks! I will look into this...