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
|