Summarise Resources between two dates into Monthly Portions

[Pete Mccann]

I hope I am posting this question in the right section of the forum. The attached spreadsheet shows an extract from a MS Project Plan of Work. We have Tasks running between two dates and one Resource allocated to each task. The Resource is Text. I would like to create formulas in the yellow cells that would summarize, by Month, the contributions from each of the resources. Is this possible in one step without using VBA?

 

[bosco_yip]

Try,

In F19, copy across to M19 and all copy down :

=SUMPRODUCT(($E$4:$E$16=F$18)*(TEXT($F$3:$AX$3,"mmm-yyy")=TEXT($E19,"mmm-yyy"))*$F$4:$AX$16)

Regards
Bosco

 

[Pete Mccann]

Bosco, that is such an elegant way to do it. Many thanks for your quick response. Perfect.

 

[Pete Mccann]

Dear all - I would like to add a follow up Post on this topic. Further to Bosco's suggestions, I have developed the spreadsheet. I have now come to a difficult position where I need some more help. I am attaching two documents: a spreadsheet that shows the concept and a word document that shows the challenge. I would really appreciate some more help on this because this would be a really useful tool to have available.

Many thanks (in advance).