Formula to sum and list highest to lowest

G

Guest

I have a list of sales people and sales amounts. I need to build a formula
that will give me each persons total sales and list them from highest to
lowest. How would I build a formula with the data below?

Steve $1000
Steve $1500
Peter $800
Peter $500
Jane $1700
 
K

Ken Wright

You hit Data / Pivot table and Pivot Chart report, drag name into ROW fields,
Amount into DATA area and it does it all for you in seconds. Is there a real
need for a formula?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

[ask] Quartile and Frequency 0
Sorting Existing Totals Into A New & Separate Column 1
Formula to get increase by 80% 1
Pulling information from a list 3
Trying to find additional ranges outside of min, max, and average 2
Formula To Show Which Cell Has The Highest Rate 9
Sum (throw out highest and lowest) 2
Reporting on Top and Bottom Sales Figures 2

Top