View Single Post
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

This one is for the name, and it's a little messy, and it requires the
formula that returns the highest valus (farther down this posting):

=IF(E2=SUMIF(A1:A8,"Amber",B1:B8),"Amber",IF(SUMIF (A1:A8,"Beverly",B1:B8),"Beverly","Blase"))

It will return a match for Amber or Beverly. It will return Blase if it
can't match the other two. You may try to refine it or see if someone can
post a more compact formula.

This one is for the value:
=MAX(SUMIF(A1:A8,{"Amber","Beverly","Blase"},B1:B8 ))

The names in curly brackets basically tell Excel to add all the Anmber
values, all the Beverly values and all the Blase values, and then return the
highest total.

Hope this helps,
tj

"Jim Gentile" wrote:

If the A column lists the salespersons name, and the B column lists their
sales. I would like a formula that will total all individuals sales, and
then list the top sales in a separate cell, with the name of that salesperson
in the cell next to the totaled sales.

For example: based on the numbers below, I would like Amber to appear in D1
and $297.69 to appear in E1. Thanks for your help.

Amber $158.69
Amber $139.00
Beverly $139.87
Beverly $41.90
Beverly $73.97
Beverly $24.95
Blase $64.99
Blase $208.98