=(C4=0)*SUMPRODUCT(E10:E13,{1.4;1.25;0.5;0.5})

--
Regards,
Tom Ogilvy


"fivermsg" wrote:


((c4=0)*((e10*1.4)+(e11*1.25)+(e12*0.5)+(e13*0.5)) )


--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=522608