Hey you guys you are terrific. Thanks
--
Therese
"daddylonglegs" skrev:
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