vanhunk
07-01-2014, 01:24 AM
Counting the people that have completed any one of a number of courses:
(Formula Result Required; Excel 2010)
I have a list of names in a column (each name in its own row) and a number of column headings in a row (let's say 4). The columns headings represent courses conducted. Say "Course 1", "Course 2", "Course 3", and "Course 4". If a person has attended one of these courses the duration of the course will be typed into the corresponding intersection of name and course.
I need to count the number of people from the list that has attend a (i.e. any) of these courses. For example, if Person1 attended one or more of the courses, it will represent a 1. If he/she didn't attend any of the courses it will represent a 0.
Thus if there are 6 people and 4 of them attended one or more of the courses, the number I am looking for is 4.
Thank you very much,
Best regards,
vanhunk
(Formula Result Required; Excel 2010)
I have a list of names in a column (each name in its own row) and a number of column headings in a row (let's say 4). The columns headings represent courses conducted. Say "Course 1", "Course 2", "Course 3", and "Course 4". If a person has attended one of these courses the duration of the course will be typed into the corresponding intersection of name and course.
I need to count the number of people from the list that has attend a (i.e. any) of these courses. For example, if Person1 attended one or more of the courses, it will represent a 1. If he/she didn't attend any of the courses it will represent a 0.
Thus if there are 6 people and 4 of them attended one or more of the courses, the number I am looking for is 4.
Thank you very much,
Best regards,
vanhunk