maybe you can adjust this example to your needs

=IF(L1="x",A1*B1)+IF(M1="x",A2*B2)+IF(N1="x",A3*B3 )+IF(O1="x",A4*B4)
you can also multiply the nested if's if you need to


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=562709