You could use the conditional formatting then a formula like

=SUMIF(B:B,"<x",A:A)

only sums values in column A where there is not an "x" in column b....


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528332