Have you tried just
= <Select cell with total in worksheet 1 + < Select Cell with total in
Worksheet 2 etc.

"Suegeo" wrote:

I need to be able to add totals from different worksheets to a single
worksheet. I am having trouble with the sum functions I have tried them all.
I think
Thanks Suegeo