In your target cell type:

=IF(F26=1,K52,SUM(K52,J52))

or

=IF(F26=1,K52,K52+J52)

They do the same thing.


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=378910