How do I total amounts on various sheets in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I use the SUM function to total amounts from one sheet to another
within the same document?
 
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
 
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)
 
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
 
Back
Top