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?