Hi Jonathan,

Am Thu, 27 Nov 2014 19:08:57 -0800 (PST) schrieb Jonathan Pence:

=iferror(arrayformula(sumproduct((O$18:O35*($B$18: $B$35=$AE15))*($M$18:$M35*($B$18:$B$35=$AE15)))/sum(($M$18:$M$35*($B$18:$B$35=$AE$15)))),"")

AE15=executed
AE14=consider

try:
=IFERROR(SUMPRODUCT((($B$18:$B$35=AE14)+($B$18:$B$ 35=AE15))*$M$18:$M$35*$O$18:$O$35)/SUMPRODUCT((($B$18:$B$35=AE14)+($B$18:$B$35=AE15)) *$M$18:$M$35),"")

could I use the same formula to satisfy the following: if A18:A35=Floating to Maturity +(or) Floating to the call AND executed +(or) consider, Sumproduct(N18:N35,M18:M35)/sum(M18:M35)

add the argument in your formula similiar the other arguments


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