J
JanetP
I have a spreadsheet that is tracking attendance and grades for a class. For
instance, column a has a list of names of people in the class; column d keeps
track of the attendance for 6/11, column e keeps track of the grade for 6/11.
column f keeps track of the attendance for 6/18; column g keeps track of the
grade for 6/18, etc. In order words, there are two columns per week. I am
using a sumif formula for the attendance that looks like
=sumif($d$6:$k$6,b$6,$d7:$k7) and that is working very well. However, I’m
having problems with the grades. Not everyone takes a test every week. I
want to be able to count the number of test scores for any given person –
some may have 2, some 5, some 10, etc. How do I get a count of tests taken
for each person?
instance, column a has a list of names of people in the class; column d keeps
track of the attendance for 6/11, column e keeps track of the grade for 6/11.
column f keeps track of the attendance for 6/18; column g keeps track of the
grade for 6/18, etc. In order words, there are two columns per week. I am
using a sumif formula for the attendance that looks like
=sumif($d$6:$k$6,b$6,$d7:$k7) and that is working very well. However, I’m
having problems with the grades. Not everyone takes a test every week. I
want to be able to count the number of test scores for any given person –
some may have 2, some 5, some 10, etc. How do I get a count of tests taken
for each person?