adding values from a date to a time line.

[jcarstens]

Hello,

I have a difficult problem . I have attached an example to help me explain what I am trying to do. I have two pages in my workbook. On sheet one I have:
Deposit 1 Date Deposit 2 Date Balance Date
1 Value Day Value Day Value Day
2 " " " " " "
3 " " " " " "

On sheet 2, I have a horizontal calendar :

Jan Feb Mar ect
1 2 3 ....

Each month has a value 1-10, vertically I have:
Deposit 1
Deposit 2
Balance

What needs to happen is in sheet 1, say the deposit for 1 was $4,000 on 2/12/07. Then I would want $4000 put in row "deposit 1" under column "2" for February. However the difficult part is there may be multiple Deposit 1's in Feb. So it needs to be able to combine all Feb deposits into that 1 cell.

Any help would be EXTREMELY helpfull. Thank You in advance.

[rylo]

Hi

See if this gives you some ideas.

rylo

[jcarstens]

Thank you,

The problem, I believe is that I will not know what the day is till it is inputed. So it will need to be able to look at the date, and determine which row in sheet 2 to place it in according to the corresponding month.

[jcarstens]

Thank you for the help, the formula seems to work. But now there is more to the equation, see the addended worksheet. I have added an additional year, so now it needs to sort by both month and year.

Any help would be great.

Thank you

[jcarstens]

Ok, I got it figured out, I just had to change the format of my cells to reflect a (month/year) style date system.

Again thank you for your help.