Excel Question
Posted 12/21/2010 10:01:18 AM by skew

I have a spreadsheet with student names and letters that correspond to attendance (A and P). Is there a formula that I can use to calculate the total number of absences (A) for each student?

I know that I can count each A manually to determine the total but with over 100 students and 45 dates it would be a tedious task.

TIA
Print Post      Close Window