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

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

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.