We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
There is currently 1 person viewing this thread.
Just setting up a betting recording system in excel for my bets to keep an eye on totals etc. I've listed my bets on one sheet with other sheets showing overall totals and then monthly totals. Overall totals has been fine as it's just a case of using the formual =sum('recordsheet'!K:K) but I wondered what the formula is to pick out all the bets made in March but leaving the remaining bets out so I can see how I do month by month. Do I use the filter or is there a formula I can use?
Excel isn't my strongest point.
Excel isn't my strongest point.
sort by:
Show
per page
Replies: 6
|
By:
filters,macros,=sumif
Take your pick. I'd go with =sumif personally. |
|
By:
Cheers Curly, that sounds good. Obviously you don't know my cell references but would you be able to give an example of how you do this using sumif?
|
|
By:
for example dates in cells A1:A20 and figures in B1:B20 and you wanted today's date
=SUMIF(A1:A20,"30/03/2010",B1:B20) and obviously edit as required. |
|
By:
I thought that's how it might be done but still don't know how to single out an entire month with this formula?
|
|
By:
at your first free column: On the same row as the date put in this formula
=MONTH($A1) (Change the A in the formula to column letter that your dates are in) Fill down as needed If the column used is column M =SUMIF(M:M,1,B:B) Change the B:B to the column letter that your data is in that you want to sum. The 1 in the formula would add all January. To add all march you would change the 1 to 3. It would be much better and easier to use Subtotals. To do that you will need a header row for filtering. |
|
By:
Thanks Compound and Curly, that's done the trick, much appreciated!
|