ExcelBanter - Find a cummulative amount

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Find a cummulative amount (https://www.excelbanter.com/excel-discussion-misc-queries/130838-find-cummulative-amount.html)

can't understand excel

Find a cummulative amount

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

Toppers

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

All times are GMT +1. The time now is 12:49 PM.