|
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 |