Cell Reference

O

onebodaciousbabe03

How do I reference the total of a formula on sheet 1 to sheet 2? I hope that
makes sense. Thank you in advance.
 
S

Sheeloo

If total is in cell H1 of Sheet1 then use this in the cell in Sheet2 you want
the total
=Sheet1!H1

If you want to sum the cells on Sheet1 in a cell in Sheet2 then use
=SUM(Sheet1!A1:A10)
 
Top