COUNTIF HELP W/BLANK CELLS

I am trying to count the number of employees that have access to work remotely and have not been furloughed or laid off. The columns I'm looking at are: MODIFIED STATUS & TELECOMMUTER. The values in Modified Status are: Furlough, Separated, Reduced Salary, Reduced Hours & Other. The values in Telecommuter are Permanent & Temporary.

I need to count all employees with the Telecommuter value of Permanent OR Temporary AND the Modified Status is NOT Furlough or Separated.

Any assistance with this formula is very appreciated.

Find more posts tagged with

Formulas

functionality

Accepted answers

Donni Matthew

I ended up having to do this: =COUNTIFS({AZ TELE}, OR(@cell = "Permanent", @cell = "Temporary"), {AZ MODIFIED}, OR(@cell = "", @cell = "Reduced Salary",@cell = "Reduced Hours",@cell = "Other (See comments)"))

But it worked!! Thank you so much!

All comments

Paul Newcome

Try something like this...

=COUNTIFS(Telecommuter:Telecommuter, OR(@cell = "Permanent", @cell = "Temporary"), [Modified Status]:[Modified Status], AND(@cell <> "Furlough", @cell <> "Separated"))

Donni Matthew

But it worked!! Thank you so much!

Paul Newcome

Happy to help. That's odd that the AND portion didn't work for you, but at least you were able to get it working.

Please be sure to flag the most appropriate response(s) as "helpful". That way others searching for a similar solution can know that one may be found here.

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.