Daily Percentage of Workers on Vacation

[Kathy M.]

Hello everyone!

I am trying to figure out a formula to show the daily percentage of workers that are off. I have 58 people total, if three people are off today, what would the percentage for today be? I thought maybe using COUNTIF to count the number of people in the column and then try to figure how to fit the percentage part in there...which I just can't seem to figure out. Then while researching it came up how to do this yearly ((# of people off)/total period) x 100 but I couldn't get that to work cause I need daily not yearly...then I though of using that yearly formula and trying adding "24 hour" in the formula which it obviously didn't like (I know it was dumb). I know it's simple...clearly my brain can't figure it out lol.

If anyone can figure this out....it would be so fantastic...and it would make my brain stop hurting.

Thank you!!

Kathy M.

[protonLeah]

Maybe this will work

=COUNTIF(B2:B65,1)/(COUNTA(A2:A65)-COUNTIF(A2:A65,"DUTY*"))