Tweaking formula to count days of the week instead of months

I currently breakdown my betting returns in months and would like to do the same for days of the week.

In the attached file you'll see the formulas to return my betting data by months/year and I need to tweak the formulas in the green highlighted cells to break them down by days of the week

Any help appreciated

Jonathan

In AC30

=SUMPRODUCT(--(WEEKDAY(INT($A$3:$A$1295),2)=ROWS($1:1)))

Copy down

Change other formulae as above.

,,,,

=SUMPRODUCT(--(WEEKDAY($A$3:$A$1295,2)=ROWS($1:1)))

INT not necessary .....

Ha ha Piet Bom you are not wrong. I was really looking to see if Saturday's were profitable or not but it seems Monday and Tuesday are the days to have a rest.

Thank you both for your help

On another note Piem Bom can you tell me how I would go about applying the "select a year" option to all my other tables in my sheet?

Tis a good idea that!

Add a drop-down in AB5 with years as per AB29

change formula:

from

=SUMPRODUCT((MONTH($A$3:$A$1295)=MONTH($AB6))*(YEAR($A$3:$A$1295)=YEAR(AB6)))

tp

=SUMPRODUCT((MONTH($A$3:$A$1295)=MONTH($AB6))*(YEAR($A$3:$A$1295)=YEAR($AB$5)))

Note: your table starts Dec 2016/ ends Nov 2017 so the above will only work on Jan-Dec for given year.

Thanks John.

Was wondering how I was going to separate my bets on a yearly basis - now I know.

Cheers

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.