Count IF , using "and", "not"

LesahDee

I am cross referencing 2 different sheets getting an error can someone help.

=COUNTIF({Munis Range 1}, "Facilities", {Contract Extensions Range 1}, NOT("Expired", "Closed"))

I want it to count if the first range is "Facilities" and if the second range is NOT "expired" or "Closed"

Find more posts tagged with

Accepted answers

All comments

DKazatsky2

Hi @LesahDee ,

Give this a try.

=COUNTIFS({Munis Range 1}, "Facilities", {Contract Extensions Range 1}, <> "Expired", {Contract Extensions Range 1}, <> "Closed")

Hope this helps,

Dave

LesahDee

thanks for responding I tried it and it says incorrect argument, UGH

AravindGP

Hi @LesahDee ,

Since you're trying to get data from two different sheets, it will be helpful if you can share which conditions belong to the different sheets.

For example, if you're trying to get a count of all facilities from sheet 1 and all open contracts in sheet 2, they are two distinct values. You will need to establish a link between the two sheets to get the consolidated number of how many facilities contracts are still open.

Alternatively, if you're trying to sum up the count of facilities in sheet 1 and the count of open contracts in sheet 2, you will need to use count if for facilities from sheet 1 + count if for open contracts from sheet 2.

LesahDee

=COUNTIF({Munis Range 1}, "Facilities", {Contract Extensions Range 1}, NOT("Expired", "Closed"))

the Facilities belong to the Munis sheet and the Expired Closed belong to the Contract extension sheet. I am not combining the numbers from the 2 sheets , just using the conditions from two different sheets.

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.