Apr 07 2022 06:18 PM - edited Apr 07 2022 06:39 PM
I need some help!! I'm not sure if it's possible to calculate attendance by organization and not by person. For example, I don't care how many people have attended a meeting for each office, because if one person from an office attends a meeting, that office is credited 100% for attending a meeting. So if an invite was sent out to 4 people in the same office and only one person attended they have fulfilled their requirement for that office. Is that possible to show that in excel where I can calculate that for each quarter?
Apr 07 2022 10:26 PM
Solution@hming If I understood correctly that could be something like this:
=IF(B2<>0,1,0)
or shorter,
=--(B2<>0)
Drag down as far as needed and format as %.
Apr 08 2022 07:41 AM
Apr 07 2022 10:26 PM
Solution@hming If I understood correctly that could be something like this:
=IF(B2<>0,1,0)
or shorter,
=--(B2<>0)
Drag down as far as needed and format as %.