Nested Formulla

Vinton Douglas

Clarity 2.png

Nick Korna

Hi @Vinton Douglas,

With the Month column with Month & Year in it, then you can use the following with a column changed to percentage:

=(COUNTIFS([Criteria Established 2]:[Criteria Established 2], "Met", Month:Month, "August 2022")) / COUNTIF(Month:Month, "August 2022")

For the other criteria just change the "Met" for the relevant criteria.

Nick Korna

Hi @Vinton Douglas,

With the Month column with Month & Year in it, then you can use the following with a column changed to percentage:

=(COUNTIFS([Criteria Established 2]:[Criteria Established 2], "Met", Month:Month, "August 2022")) / COUNTIF(Month:Month, "August 2022")

For the other criteria just change the "Met" for the relevant criteria.

Vinton Douglas

Fantastic!! Thanks a lot.