Forum Discussion
Solved
Using Excel to Calculate Meeting Attendance by Organization
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 ...
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 %.
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 %.
Thank you so much!!