Hello! I need help with a formula, experience with Countifs OR AND formula?

I am not sure if I am doing this right, I need to count "reference another sheet" if status is closed, completed OR sent to contractor (any of them), AND program is "APD".

Here is my formula:

=COUNTIFS(OR({Classification Review Status}, "Completed", {Classification Review Status} = "Closed", {Classification Review Status} = "Sent to contractor"), AND({Classification Review Program}, "APD"))

It says Invalid Data Type, I am not sure if I can use this formula when reference to another sheet

Find more posts tagged with

Accepted answers

All comments

Kelly Moore

Hey @Paola Preciado

Try this

=COUNTIFS({Classification Review Status},OR(@cell= "Completed", @cell= "Closed", @cell= "Sent to contractor"), {Classification Review Program}, "APD")

Will that work for you?

Kelly

Paola Preciado

That worked! Thank you So much Kelly!

Paola

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.