Sumproduct help

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

Hi. I am doing a Lunch Detention spreadsheet for my
school and I have included 18 different classes on 18
different sheets, with all of the students from the
different classes on their respective class rosters. I
also have at the front of the class sheets a separate
sheet that includes a list of teachers and a box for each
month of the school year to add up how many lunch
detentions a specific class has in a single month. I also
have a box above each day of the school year and have the
number of the month that we are in above it to separate
the months (Jan. ="1", Feb="2" and so on). If a student
has lunch detention, I put an "L" in students box.

My questions is how do I add the number of lunch
detentions from the "Room 4" sheet onto the first sheet
to the box where room 4's total should go ("Teacher's
List" F9 (for Sept. Lunch Detentions))? Room 4's sheet
should start counting at D10 and end at IB43. It all has
to correspond to the number of what month it is and those
numbers are in D9-IB9.

I don't have any drop down boxes or anything so I wasn't
sure if I had to do something else or what. Thank you so
much for any help at all :)
 
I believe you should use COUNTIF. If you send me the workbook, I could
probably do it for you. It's a great thing you're doing for your school!
 
I did it!! Thank you so much!! I would have never thought
of using the countif function. Thank you for the offer of
help. I really appreciated it.


john
 
Back
Top