linking a value from another page or tab in a formula

R

Reynolds

How do I take a value from another page in my spread sheet take changes
often and add it to the formula on another page or tab?
 
S

Shane Devenshire

Hi,

Suppose the changing cell is A1 of Sheet2 then on sheet1 select your
formula, say
=SUM(B5:B100)
and modify it to read
=SUM(B5:B100)+Sheet1!A1

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
Top