Formulla to generate met, not met, partially met and N/A

Vinton Douglas

Hello,

Can any one help?

I need a formulla to generate the % "Met", "Not Met", "Partially Met" and "N/A" which is provided in a spreadsheet on a monthly basis. So I will have one spreadsheet with the incoming data.

The formulla generates "# Divisible by zero (see attached):

I am using the following formulla:

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

I presume, I need to insert the year somewhere but need some help also

For Clarity.png

-see attached

Vinton Douglas

I try this formulla, but its not working. Can anyone say whats wrong?

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

Paul Newcome

Try changing "August" to "August 2022" so that it actually matches the source data.