How do I total amounts on various sheets in excel?
 

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

"ExcelNewby" wrote:

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

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)

--
Ian
--
"ExcelNewby" wrote in message
...
How do I use the SUM function to total amounts from one sheet to another
within the same document?

How do I total amounts on various sheets in excel?
 

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

"FSt1" wrote:

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?

How do I total amounts on various sheets in excel?
 

Read the suggestion again and don't forget the punctuation.
--
David Biddulph

"RABAB ALI" <RABAB wrote in message
...
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

"FSt1" wrote:

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?