Find a cummulative amount

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with cummulative totals 3
Another sumif question 1
cummulative sums 1
Date and amount of last payment 3
SUM PRODUCT & CUMMULATIVE BALANCE 3
FORMULA HELP any body 4
Complex IF Statement 7
Cummulative counting in a query 5

Back
Top