Solved how can i calculate payments for next 5 days, all separate?

July 18, 2013 at 07:58:00
Specs: Windows XP
excel demo
jus like i calculated payment for the next day at the bottom. i wan to calculate any payment coming day after tomorrow..
this means
if its 1/7/13 today
I want it this way
2/7/13 10000
3/7/13 20000
4/7/13 30000
5/7/13 40000
6/7/13 50000
7/7/13 60000

than i want total of all these..
PLEASE SEE MY SHEET.


See More: how can i calculate payments for next 5 days, all separate?

Report •

#1
July 18, 2013 at 11:27:59
✔ Best Answer
I'm not 100% clear on what you are trying to do since the numbers in your text (10000, 20000, etc.) don't seem to correlate with the numbers in your ScreenCast (5, 10, 15, etc.)

Perhaps this is what you are looking for?

In my example, I entered =SUM($B$1:B1) in C1 and dragged the formula down to C4

The $B$1 means that the B1 reference will be locked as you drag the formula down, but the B1 (without the dollar signs) will increment (B2, B3, etc.) each time, adding in one more cell.


         A             B             C
1     3/7/2013       10000        10000   <----   =SUM($B$1:B1)
2     4/7/2013       10000        20000
3     5/7/2013       10000        30000
4     6/7/2013       10000        40000

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question