Hi,

Am Wed, 19 Feb 2014 16:56:15 -0800 (PST) schrieb :

Works well with one exception. The total appears after every occurrence of the bidders number. For example, if bidder 500 bid on three items, the correct total appears on each of those rows. Any solutions?

in C2 try:
=IF(COUNTIF($A$2:A2,A2)=1,SUMIF(A:A,A2,B:B),"")


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2