How do I total amounts on various sheets in excel?

[ExcelNewby]

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

 

[FSt1]

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

 

[Ian]

Assuming the sheets are consecutive tabs and the same cell is to be added on
each sheet, in a cell on your summary sheet type =SUM( then click on the tab
of your first sheet, hold shift and click on the tab of your last sheet,
then type the cell reference and close the bracket. You will end up with
something like

=SUM(Sheet2:Sheet6!A1)

 

[RABAB ALI]

Hi,

I tried that for a subtraction sheet1A1-sheet2a1..and it is not working.
Basically I have 2 sheets within the same workbook and I want to subtract
each cell in sheet 2 from the corresponding cel in sheet1

Thanks
Rabab

 

[David Biddulph]

Read the suggestion again and don't forget the punctuation.