Find a cummulative amount

  • Thread starter can't understand excel
  • Start date
C

can't understand excel

Please help me!I'm new at this!

I need to find a cummulative amount.
What's the formula to get the sum of an amount in sheet 1 plus the amount on
sheet 2 ?????
Thanks in advanced
 
T

Toppers

Add same cell on different sheets

=SUM(Sheet1!A1+Sheet2!A1)

=SUM(Sheet1:Sheet2!A1)

Or summing a range of cells ..

=SUM(Sheet1!B1:B10+Sheet2!C1:C10)

HTH
 
Top