Forum Discussion
I need a formula to SUM the Bank and ROI columns by day / week, etc. for single and Multi Bet 2,3,4
noporschenolife Here is a formula for the day by day running total and you should be able to modify for the other columns:
=IF(Bets!A27="", "",IF(Bets!A27=MAX(Bets!A$11:A26),Bets!AC27+INDEX(Bets!AC$11:AC26,MAX(ROW(Bets!A$11:A26)*ISNUMBER(Bets!A$11:A26)-ROW(A$10))),Bets!AC27))Basically it checks if this date is = to the max of all previous dates (i.e. doesn't care if there are spaces) then if so it INDEXes the column of data based on the last row that ISNUMBER.
BTW if you are using Excel 365, you might be able to make an easier formula using FILTER and LET functions.
noporschenolife Here is a formula for the day by day running total and you should be able to modify for the other columns:
=IF(Bets!A27="", "",IF(Bets!A27=MAX(Bets!A$11:A26),Bets!AC27+INDEX(Bets!AC$11:AC26,MAX(ROW(Bets!A$11:A26)*ISNUMBER(Bets!A$11:A26)-ROW(A$10))),Bets!AC27))Basically it checks if this date is = to the max of all previous dates (i.e. doesn't care if there are spaces) then if so it INDEXes the column of data based on the last row that ISNUMBER.
BTW if you are using Excel 365, you might be able to make an easier formula using FILTER and LET functions.
Now I will try to use your formula and see how it works. And my excel says that this "," character in the formula is wrong and I have to use this ";" character. Anyway, I can't believe someone answered me on the internet and helped, I'm very glad. The fact that you described how this formula works sounds simple, but I myself would not have thought of this myself, since I am simply not yet familiar with these formulas (MAX, INDEX and ISNUMBER, as well as what you wrote about filters) ... You are smart. If the formula works, how can I thank you?
- You're very welcome and if you have any questions about how they work or problems getting them to work just let me know. Your appreciation and thanks is all we ask for 🙂
- Okay, but I have a more interesting proposal for you. Let's agree on 2.5% of my bank(net money without tax on winnings and interest on the transfer) in 2 years, so to speak, with witnesses on this site. Also, every month I can send my table with attached screenshots from the bookmaker's office, from the moment I start playing. This will be an additional incentive for me to earn more. The only thing I need is a contact with you, which you will never delete and will always be available (write me your name and your mail or any other social network in private messages). If I have more questions about the table, I will write to you here. Thank you for everything.
