Excel and adding cells items...

[Ivan T. Williams]

Does anyone know how to add an item from a cell on sheet 1 to a cell on
sheet 2?

[Dave Peterson]

if the formula cell is on sheet2.

='sheet1'!a1+b99
(b99 is on sheet2, so it doesn't need the sheet name in front of it.)

"Ivan T. Williams" wrote:
>
> Does anyone know how to add an item from a cell on sheet 1 to a cell on
> sheet 2?

--

Dave Peterson