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


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

-see attached


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!