linking a value from another page or tab in a formula

  • Thread starter Thread starter Reynolds
  • Start date Start date
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?
 
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

using the =page! feature to transpose a row to column 0
SUMIF, 3D FORMULA, EXCEL FORMULA HELP 1
Formula Help 1
value error 4
Dependent drop down dynamic range formula, off sheet. 7
Data Updating queries 2
Scrabble Value calculation for Welsh words 0
Count the columns from one sheet and paste it in another sheet 0

Back
Top