I'm not quite sure what condition you want the cells in col X and Col W
to meet to have the corresponding cell in col r added to the sum.

Could you perhaps show a small example?


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=504917