Countifs Cross sheet reference

I found this similar issue and used the answer to fix my problem, but it didn't work for me.

=COUNTIFS({Sheet - Contract Management - Complete Lib Range 3}, "Executed", {Sheet - Contract Management - Complete Lib Range 4}, "A&E")

However, I am getting a 0 return which I know is not correct. The column that has the program type "A&E", is a dropdown list. Would that affect the formula?

Find more posts tagged with

Accepted answers

All comments

jmyzk_cloudsmart_jp

Hi AliT

I do not know why your formula does not work, but according to my test, "COUNTIF with the dropdown list criteria range with the same formula does.

Please take a look at this dashboard.

https://app.smartsheet.com/b/publish?EQBCT=08dbf58d299f489bb5a9e56f1430b961

AliT

Thank you for running the test. I am stumped as to why my formula is not working. Everything in your test, matches what I have. So odd.

AliT

jmyzk_cloudsmart_jp!!

One of my references was pointing at the wrong column! Once I fixed that, it is working now!!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.