Find String Associated with Large Sum

[henrychan]

Edit: Title should be "Find String Associated with Cumulative Sum"

I'm trying to solve a problem using a formula that finds the string associated with a maximum cumulative sum.

More specifically, I am trying to write a formula that finds the top seller by cumulative number of sales and cumulative profit.

Any help would be greatly appreciated!

[dosydos]

try making a table with the artist names and using a sumif formula.

Artist	Sales	Profit
Britney	=SUMIF(C:C,D27,A:A)	=SUMIF(C:C,D27,B:B)
Madonna	etc..	etc..
Beyonce
Janet

For my table "Britney" is located in D27

[henrychan]

Hi dosydos,

Thanks for response. I understand that I can create a table for each artist and use the SUMIF function, but is there a way to compare the sales/profit totals between artists.

Essentially, I need to come up with a formula that will give me the answer. Can't create tables.