Hi Steve ,

The formulae are :

=SUMPRODUCT(plan1[Duration]*plan1[% Complete])/plan1[[#Totals],[Duration]]

What this does is multiply each **Duration by its corresponding % Complete** to arrive at the total number of days that have been taken by the project so far ; dividing this by the total number of days gives a percent rating ; this will not be accurate , since several activities may be going on in parallel , but for want of anything more accurate , I think this will have to do ; probably if you can have the activity dependencies , we can arrive at the actual time taken vs. the project time , but I doubt that this can be done using only formulae ; VBA can possibly do this.

The next formula is :

=(plan1[[#Totals],[Sell Price ($)]]-plan1[[#Totals],[Cost ($)]])/plan1[[#Totals],[Sell Price ($)]]

which is just the formula you posted for calculating margin ; since we want an overall margin , we consider only the totals for the cost and selling prices.

The last one is :

=SUMPRODUCT(plan1[Cost ($)]*plan1[% Complete])/plan1[[#Totals],[Sell Price ($)]]

which is to calculate the Actual Margin as on date ; it multiplies each activity cost by the percent completed , and divides the sum of all these by the overall selling price total.

Regarding the others , give me some time to work on them.

Narayan