Hi Jonathan,

Am Fri, 28 Nov 2014 07:26:41 -0800 (PST) schrieb Jonathan Pence:

I tried this:
arrayformula(SUM(IF(($A$18:$A$35="fixed - no swap")*($B$18:$B$35="proposed w/itw")+($B$18:$B$35="proposed w/desk"),$M$18:$M$35)))

try SUMPROSUCT instead:
=SUMPRODUCT(($A$18:$A$35="fixed - no swap")*(($B$18:$B$35="proposed w/itw")+($B$18:$B$35="proposed w/desk"))*$M$18:$M$35)
and make sure that the added part in column B is in brackets:
(($B$18:$B$35="proposed w/itw")+($B$18:$B$35="proposed w/desk"))
Each argument in brackets and the sum in brackets

then, for the combined total tried this and worked:

arrayformula(sum(if(($A$18:$A$35=$F$142)*($B$18:$B $35<"-"),$M$18:$M$35)))

You can also use a SUMPRODUCT to avoid the curled brackets:
=SUMPRODUCT(($A$18:$A$35=$F$142)*($B$18:$B$35<"-")*$M$18:$M$35)
or
=SUMPRODUCT(--($A$18:$A$35=$F$142),--($B$18:$B$35<"-"),$M$18:$M$35)



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