sum cells based on specific criteria

I am attempting to create a log to record and compile cycling information. my intention is to have a row for each day of the year, with date and day listed in separate columns. next, i will record length of each ride, miles ridden, elevation gain, etc. I then want excel to sum each category for each month as well as for each week. no problem if except that i want this to be easily repeatable each year without having to cut and paste all the formulas to reflect new cells as the days of the week rotate through. is there a way to get excel to check for the day of the week in one cell, and then to add the next several cells so that i get cumulative info for that week?
so if column A has date, Column B has day of week, maybe cell B5 is a monday. can i get Excel to then check column B for "Monday" and then add the contents of C5 plus the next 6 cells in Column C? not sure if i made this very clear, hopefully someone can help. Thanks!!

I rarely use excel, so am really struggling to get this the way i want it. i kind of understand the logic of some of it, but struggle with other aspects.

Here's what i have so far, if you could look at it that would be great!
i decided an easy work-around for the week was to enter date based on first Monday of new year, then add-subtract from that to keep it consistent.
i think this is the same question i asked earlier, but now applied instead to the months. if you look at the sheet titled "summaries" you will see that i used to go in and manually change the cells that it added for each month. i could still do that, but i'd rather have a way for it to query for january 1st, then add up the correct cells in the range for that stat, and so on. in your sheet, i wasn't sure how to follow your function (i know, probably simple for people who use the program a lot). so not sure how to use it in this application.

Originally Posted by Spencer101

=SUMIFS('Ride Log'!$H$4:$H$374,'Ride Log'!$F$4:$F$374,">="&A3,'Ride Log'!$F$4:$F$374,"<="&EOMONTH(A3,0))

The above would be your formula in cell B3 of the Summaries worksheet, and copied down to the other months.

I know it looks like gibberish if you're not used to reading Excel formulas but it's quite simple really.

Syntax in simple to read terms would be =SUMIFS(RangeToSum,RangeToTest1,Condition1,RangeToTest2,Condition2) You can have more than two conditions so you would just add them as needed.

Basically, in plain English, the formula above says "Sum the figures in column H on 'Ride Log' where the corresponding date in column F is greater than or equal to the 1st Jan and less than or equal to the last day in Jan".

Does that make it any clearer????
I suspect not...

ok. it looks like i then change the H twice to the appropriate column for each of my other data? so I for Time, L for elevation, and O for TSS score, and everything else would stay the same?

and i'm assuming i would have to change the condition for each month? i'm having trouble picking that out....

I sure appreciate you walking me through this! i cut and pasted your formula, then filled down (is that the same as copy down?) when i added test numbers, it doesn't do anything. would you mind looking at it again here?

hmmmm. still didn't work.

That'll do for sure! Thanks so much for your help on this. since creating this i generally only go back once a year to modify, and always struggle to figure out how to change it. With this overhaul, it will make my life so much easier!

rep to you, and you are certainly a gentleman and a scholar