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!
|