Collating Attendance for Online Lectures from Google Forms
Channel: Smitha Renny
Date: 2020-07-27

This video explains how you can collate the attendance taken during online lectures (present in Google Forms), into a single Excel workbook. It also explains how to get the count of attended lectures for each student.

For getting the count for each student, the following formula is to be used in Excel:(Pl edit the formula according to your specific worksheet)

=SUMPRODUCT(COUNTIF(INDIRECT("'"&C2:C4&"'!A2:A6"),E2))

In the above formula:
    A2:A6 is the data range that you want to count the specified value across worksheets;
    C2:C4 is the sheet names list which include the data you want to use;
    E2 is the criteria that you want based on.