I am trying to sum grades for a class. When recording the grades I have a
grade for in class and one for homework so the column headings alternate
between the date, HW(for homework) and a possible column for projects. I
want to total each of the three types of grades seperately so I need to use
the column heading to determine if the column is added and it is fine for the
HW and project columns but I want to write the equation so that the in class
grade is added if the heading is a date. I hope this makes sense.