|Your looking for a =SUMIF solution.|
all Bs are days and the C's are the value
So in Cell D1 will be your totals for all Mondays:
Cell D2 will be your totals for Tuesday:
I've only used from cell B/C 1 through B/C 45
Modify to suit your needs.