hi,
2 ways.
if already totaled on the different sheets and assuming the totals are in
A1...
=Sheet1!A1+Sheet2!A1+Sheet3!A1

if not totaled and assuming the columns to total are all column G....
=sum(sheets1!G2:G50)+Sum(Sheet2!G2:G50)+Sum(Sheet3 !G2+G50)

Regards
FSt1

"ExcelNewby" wrote:

How do I use the SUM function to total amounts from one sheet to another
within the same document?