Hi Jonathan,

Am Fri, 28 Nov 2014 06:58:20 -0800 (PST) schrieb Jonathan Pence:

thanks. that works, but when i want to split out the groupsets, like "executed w/itw + executed w/desk", and then "Proposed w/itw + proposed w/desk", how to I isolate them only? do I need to use a different funtion than "-" or just change it?

for G142 and G143 e.g. try:
=SUMPRODUCT(($A$18:$A$35=F142)*(($B$18:$B$35=G142) +($B$18:$B$35=G143))*$M$18:$M$35*$O$18:$O$35)/SUMPRODUCT(($A$18:$A$35=F142)*(($B$18:$B$35=142)+( $B$18:$B$35=G142))*$M$18:$M$35)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional