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)

"onebodaciousbabe03" wrote:

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