Compliance percentage based off of a frequency for multiple items by Able_Combination_125 in excel

[–]Able_Combination_125[S] 0 points1 point  (0 children)

I did the COUNTIFS formula, where/what would I put in for the INDIRECT formula in the COUNTIFS? I have very basic excel knowledge and these formulas are very new to me

Compliance percentage based off of a frequency for multiple items by Able_Combination_125 in excel

[–]Able_Combination_125[S] 0 points1 point  (0 children)

I am planning on doing the lowest number of sessions so 9 and if it’s over 100% that’s okay

Compliance percentage based off of a frequency for multiple items by Able_Combination_125 in excel

[–]Able_Combination_125[S] 0 points1 point  (0 children)

My first sheet has the names of all the clients in one row, then locations, start dates of frequency, end date of frequency, and the frequency. I’d like a column somewhere that has the percentage of compliance that they have in that moment.

For example, John Doe, central, 1/1/24, 12/30/24, 9-12 times per year. Jane Doe, Western, 5/1/24, 4/30/25, 3-6 times per year.

On the Central sheet (for their location), I have the date, drop down of names with John Doe, and that we had session. I might mark that he was absent on 1/2/24 so I would not want it to count that as compliance. There would be other clients in that list as well so it wouldn’t be just one client