Hi Jonathan,

Am Fri, 28 Nov 2014 04:38:48 -0800 (PST) schrieb Jonathan Pence:

B18:B35 search field, find G142:G147 (in this case G144=executed w/itw + G145=executed w/desk + G146=Proposed w/itw + G147=proposed w/desk)
Executed w/itw
Executed w/desk
Proposed w/itw
Proposed w/itw

Tried:
IFERROR(SUMPRODUCT((($A$18:$A$35=$F$142)*($B$18:$B $35=$G$144)+($B$18:$B$35=$G$145)+($B$18:$B$35=$G$1 46)+($B$18:$B$35=$G$147))*$M$18:$M$35*O$18:O$35)/SUMPRODUCT((($A$18:$A$35=$F$142)*($B$18:$B$35=$G$1 44)+($B$18:$B$35=$G$145)+($B$18:$B$35=$G$146)+($B$ 18:$B$35=$G$147))*$M$18:$M$35),"")

if you want add all values from G142:G147 you can also try
$B$18:$B$35<"-"

Try:
=SUMPRODUCT(($A$18:$A$35=F142)*($B$18:$B$35<"-")*$M$18:$M$35*$O$18:$O$35)/SUMPRODUCT(($A$18:$A$35=F142)*($B$18:$B$35<"-")*$M$18:$M$35)


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