View Single Post
  #1   Report Post  
Brian
 
Posts: n/a
Default Formula to sum and list highest to lowest

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