Same formula on multiple sheets

  • Thread starter Thread starter onebodaciousbabe03
  • Start date Start date
O

onebodaciousbabe03

How can I get the total of a specific formula on worksheet 1 to be on
worksheet 2 as well? I hope the question makes sense. Thank you in advance
for the help!
 
If you mean what you seem to mean - that (for example) Sheet1!$B$43 has the
formula =SUM(B$2:B42), which displays 12,345, and you want to display the
result 12,345 on Sheet2!$C$5, then on Sheet2 in cell C5 you simply put the
formula =Sheet1!$B$43. Whenever the sum changes, the value displayed on
Sheet2 changes too. But maybe you meant something more complicated than that.
 
Back
Top