Attendance Spreadsheet summary

[mhcoats]

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!

[NBVC]

I am not sure I understand what results you want to see?

Where are the formulas to go and what exactly are you summing/counting?

[mhcoats]

Sorry about that. I updated my sample spreadsheet and highlighted where the info can go, hopefully this will make it clearer. I also manually added the data I need a formula (or formulas) for. I want to know how many Freshmen, Sophomores, Juniors, and Seniors attended each session.

Thanks, and again, let me know if you need any more info!

[NBVC]

I can assume, I think correctly, that a Junior is Grade 9, A sophomore is grade 10.. but what exactly is a Junior and a Senior? (where's the breakpoint?)

[NBVC]

G11: =SUMPRODUCT(--($B$2:$B$8=9),--(G$2:G$8<>""))

G12:=SUMPRODUCT(--($B$2:$B$8=10),--(G$2:G$8<>""))

G13: =SUMPRODUCT(--($B$2:$B$8<=10),--(G$2:G$8<>"")) assumes junior is 9 & 10

G14: =SUMPRODUCT(--($B$2:$B$8>=11),--(G$2:G$8<>"")) assumes senior is 11 or above

all copied across, horizontally.

[mhcoats]

perfect! thanks!