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 60000than i want total of all these..

PLEASE SEE MY SHEET.

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.

Ask Your Question

Weekly Poll