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

"Reynolds" wrote:

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?