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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Publisher adding blank page when printing my booklet... 2
Adding a comment in a footnote area 1
Newbie Help - IF Yes No Function 0
Bugs in Office 2019 0
Section and Page numbering 0
Drop down list control value in vba 2
Autonumber field in Excel that behaves the same as Access 0
Adding data to MS Access from csv file 0

Top