Forum Discussion

linrojy's avatar
linrojy
Copper Contributor
Feb 28, 2020

Percentage of attendance

Hi all,   How can I calculate the percentage of attendance using excel?
excel
Formulas and Functions
PReagan's avatar
PReagan
Bronze Contributor
Feb 28, 2020

Hello linrojy,

 

I'm afraid you will have to elaborate...

 

In general:

=[group1]/[total_group]

Would generate the percentage of total population that is compiled of group1.

    • PReagan's avatar
      PReagan
      Bronze Contributor
      Feb 28, 2020

      linrojy 

       

      Are you looking for an individual's actually attendance vs their scheduled amount of time? An individual's attendance vs the entire group's attendance? Or something else?

      • linrojy's avatar
        linrojy
        Copper Contributor
        Feb 28, 2020

        Im looking for individual's actually attendance vs their scheduled amount of timePReagan 

  • linrojy's avatar
    linrojy
    Copper Contributor
    Feb 28, 2020

    PReagan  let me show you the data that I have, give me few minutes

Resources