Hi new to the forum, but would appreciate help.

I have a table which has planned hours and an overall estimated % completed. For multiple items how do I find the overall % complete.

.........................Wk 1........Wk 2..............etc etc
Planned .............10...........10
Actual ...............10............0
Estimated %........40%

Planned ..............5............25
Actual ................5.............0
Estimated %........19%

Planned ..............4.............16
Actual ................4..............0
Estimated %.......20%


I need a function which will multiply each estimate by its associated planned hours and then multiply the total planned by the resulting composite %.
ie.70/(20*40%)+(30*19%)+(20*20%) = 0.253.

I have tried various sumif and countif functions but can't get them to work.

As the spreadsheet will be populated by non-excel techies, the function must be able to be copied when new columns and rows are added.

Thanks in advance
Spoed