Excel Formula Help

[»freakmonger]

Ok I made a spreadsheet to keep track of bets and profits from those bets.

 

I'm trying to get the "Most Profitable Event" and "Most Bets" calculated. Row D lists the Events and K lists the Profits from that bet.

 

What formula can I do to get the most profitable event? i.e. if I've made $20 from baseball events and $5 from football events, "Most Profitable Event" should show "baseball". But I don't know what formula I need.

 

To help I posted a screenshot of the excel sheet.

 

 

http://www.freakmonger.net/imgs/bookie1.jpg

[»Xog]

i think u and me are the richest people on here

[Samapico]

Use the SUM.IF thing; You'll have to make a SUM.IF to sum the baseball events, another for football, etc. , then you can use a max() to get the most profitable one (though this will give you the amount of $, not the event name), but then you can probably use one of the Find functions to get the name of the event written beside that number.

[»freakmonger]

yea I ended up adding every Event and just used SUM to get the total profit for each event. Didn't want to do it that way but it was the quickest way for me to get it done.

[Guest Positron]

This might help, but im not quite sure it does what you want it to do.

Find the max then find the row of the most profitable event.

 

ROW( MAX( cellrange ))

then have it put in the COLUMN number of wherever the event is posted. Not quite sure how to do that.

 

Or do you want to total each event then find which one is most profitable? or do you want to return the event which had the most profit?

Edited April 10, 2010 by Positron