Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to read a blank cell as zero for formulas? | Excel Discussion (Misc queries) | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |