Attendance Spreadsheet summary

Hopefully this thread is in the right section....

I am creating a large spreadsheet that holds attendance information for a high school program. There are several pieces of data I need to gather from the attendance log and I have been successful with most. However, I need to record how many students, by grade level, attend each session.

Each day of the week, Mon-Thurs, is considered a separate session (Monday Session, Tuesday Session, etc) so that I have 4 sessions total that are held for 10 weeks at a time. Confusing? Sorry!

I have attached a sample spreadsheet (a very basic version) that will hopefully clear things up. I need something like a combination of a SUMIF and a COUNTIF formula...a formula that will simply count criteria but will give me the the ability to select the range and the "count_range" as in the SUMIF formula.

However, I could be totally off and a completely different formula may do the trick!

Please let me know if you have any more questions, and thank you in advance!