Hi scoutleader,
Will this function do what you want? =SUMIF(D$2:D$7,"X",E$2:E$7)
It assumes winners in column D, winning bids in column E, values from
rows 2 to 7 and bidder is X.
Ken Johnson