SUMIF Help

  • Thread starter Thread starter CharlieCC
  • Start date Start date
C

CharlieCC

Greetings.

I am running a silent auction and would like to sort the bids by bidder andthen 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 at500). 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
 
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
Click to expand...

=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 (e-mail address removed):
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?
Click to expand...

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


Regards
Claus B.
 
Back
Top