New Posts For Thread: Excel formula queryhttps://community.betfair.com/general_betting/go/thread/view/94082/23535642/excel-formula-queryJust 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 usingThanks Compound and Curly, that's done the trick, much appreciated!https://community.betfair.com/general_betting/go/thread/view/94082/23535642/excel-formula-query?post_id=420931038#420931038Thanks Compound and Curly, that's done the trick, much appreciated!Tue, 30 Mar 2010 09:07:38 -0500at 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 neededIf the column used is column M=SUMIF(M:M,1,B:B)Change the B:B to the columnhttps://community.betfair.com/general_betting/go/thread/view/94082/23535642/excel-formula-query?post_id=420931034#420931034at 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 neededIf the column used is column M=SUMIF(M:M,1,B:B)Change the B:B to the columnTue, 30 Mar 2010 08:51:08 -0500I thought that's how it might be done but still don't know how to single out an entire month with this formula?https://community.betfair.com/general_betting/go/thread/view/94082/23535642/excel-formula-query?post_id=420931018#420931018I thought that's how it might be done but still don't know how to single out an entire month with this formula?Tue, 30 Mar 2010 08:32:37 -0500for 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.https://community.betfair.com/general_betting/go/thread/view/94082/23535642/excel-formula-query?post_id=420931002#420931002for 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.Tue, 30 Mar 2010 08:14:17 -0500Cheers 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?https://community.betfair.com/general_betting/go/thread/view/94082/23535642/excel-formula-query?post_id=420930978#420930978Cheers 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?Tue, 30 Mar 2010 07:20:58 -0500filters,macros,=sumifTake your pick. I'd go with =sumif personally.https://community.betfair.com/general_betting/go/thread/view/94082/23535642/excel-formula-query?post_id=420930958#420930958filters,macros,=sumifTake your pick. I'd go with =sumif personally.Tue, 30 Mar 2010 06:55:59 -0500Just 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 usinghttps://community.betfair.com/general_betting/go/thread/view/94082/23535642/excel-formula-query?post_id=420930950#420930950Just 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 usingTue, 30 Mar 2010 06:46:40 -0500