Greetings.

I am running a silent auction and would like to sort the bids by bidder and then total each person's sum. In other words, the same person may bid on multiple items that are not sequential. However, no names are entered, rather, each person has a unique bid number (in this case the numbers begin at 500). Obviously, entering each bidder's number is not an efficient way (100-150 potential bidders!). What does the formula look like so that a couple of clicks will give me the information I need?

I won't even bother you with what I've tried.

Thanks for all your help.

Charlie

On Tuesday, February 18, 2014 7:11:25 PM UTC-6, CharlieCC wrote:
Greetings.



I am running a silent auction and would like to sort the bids by bidder and then total each person's sum. In other words, the same person may bid on multiple items that are not sequential. However, no names are entered, rather, each person has a unique bid number (in this case the numbers begin at 500). Obviously, entering each bidder's number is not an efficient way (100-150 potential bidders!). What does the formula look like so that a couple of clicks will give me the information I need?



I won't even bother you with what I've tried.



Thanks for all your help.



Charlie

=SUMIF(A:A,$A2,B:B)

Thanks, Don.

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?

Cheers,
Charlie

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

Works like a charm, Claus.

Thank you.