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
Bookmarks