Using Excel to Add up milestone payments

**Madball** · 10-02-2007, 06:18 AM

Hi all,

I'm currently trying to create a calendar based system which sums up all the milestone payments in each month. I'm currently coming to a situation where I am stuck. I will try and explain what I'm trying to do in more detail and hopefully one of you nice people will be able to help me out :D

OK Currently I have in column A on sheet 1 a list of titles/projects that the company is working on (I can't go into detail on what titles they are because it will breach my NDA). From column B onwards is months of the year along the top (Jan, Feb, Mar etc).

In each month I want to be able to put MS1 (Milestone 1) MS2 etc or which ever month one of the 9 milestones land on. Each Milestone has a payment attached to it, for example MS1 = £580,000. These will be listed on Sheet 2. So at the bottom of each column on sheet 1 I want it to sum up all the milestone payments in each month by looking into sheet 2. Just wondering if this can be done.

I've been messing with DSUM and INDEX but I'm not having any luck at the moment

**VBA Noob** · 10-02-2007, 06:28 AM

Unloading a example worksheet would of being better so we can see the layout

Could you use countif to Count the

=COUNTIF(H:H,"MS1")*58000

VBA Noob

**Madball** · 10-02-2007, 06:31 AM

Please Login or Register  to view this content.

This is the formula that I'm using at the moment but that will only work if MS1 is the same payment for all projects. Since we are working with more than 1 clients MS1 is actually 2 different payments. I will try and upload a test sheet, but hopefully you might be able to see what I'm talking about from the formula.

**Madball** · 10-02-2007, 06:45 AM

OK please find attached a dummy file with all the stuff you will need. on Sheet 1 you will see a total at the bottom in each column I want it to add up the MS1, MS2, MS3 etc for each month and give me the total amount of money from sheet 2.