Track my betting results
Hello!
I am trying to make a Excel spreadsheet that shows which leagues and countries I have been most profitable with my bets. I am not very good at using Excel and want to save myself the work of manually calculating how many bets in this league and that country I have won. Can anybody help with this?
I would really appreciate some help! :D
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
If you go with search engine, there are n number of templates. Select as per your requirement.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Here is the Excel-spreadsheet that I have used up to this point. The A-row is the date which the bet was put, B-row is the country and/or league in which the bet is, C is the game I have placed a bet on, D is the type of bet: DNB: draw no bet, AHC: asian handicap, O/U: over or under a certain amount of goals and 1x2: home team to win, draw or away team to win. E is which bet I placed, so in a 1x2 bet I have placed a bet on 1, meaning the home team. Row-F is the odds I placed the bet on, G is how much I placed on the game, H is wether or not the bet won: V, lost: T og was a void: TB. Finally there is row-I which is how much profitt I made on that specific bet or how much I lost. Thanks for all help!
Hello Dealiono and Welcome to Excel Forum.
If the values in column I were changed from text values to numeric values (modeled in I2:I4) then the following would work:
1. Populate a list of distinct countries/leagues using: =IFERROR(IF(MATCH(0,INDEX(COUNTIF(M$1:M1,B$2:B$555),,),)>COUNTA(B$2:B$555),"",INDEX(B$2:B$555,MATCH(0,INDEX(COUNTIF(M$1:M1,B$2:B$555),,),))),"")
2. Find the total of the values in column I per country/league using: =SUMIFS(I$2:I$555,B$2:B$555,M2)
Note that for I2:I4 the custom formatting rule is: 0.00 kr
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks