View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Find a cummulative amount

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

"can't understand excel" wrote:

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