i have found the exact thing i want in excel 2007, but it's not in the
older 2003 version.

I have 2 columns, say A and B, if it is current in one and the other
says sold in it then i want that to increment once.

all i want is the totals of the amount that correspond.

Can any one help me please.

Andy


--
AndyBrown
------------------------------------------------------------------------
AndyBrown's Profile: http://www.excelforum.com/member.php...o&userid=36594
View this thread: http://www.excelforum.com/showthread...hreadid=563322