Forum Discussion

hming's avatar
hming
Copper Contributor
Apr 08, 2022
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 ...
  • Riny_van_Eekelen's avatar
    Apr 08, 2022

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

     

Resources