Using COUNTIFS

Hi,

I am using the following formula to count those occasions when CSOD (unit) is impacted by CFCD (unit) and the status of the impacts is either 'conceptual' or 'complete' and it does not work. If I limit it to only counting 'conceptual' it works. What I am missing to count more than one status?

Thanks

Phil

Find more posts tagged with

Formulas

Accepted answers

Genevieve P.

Hi Phil,

The reason it's not working is that you're looking for two criteria separately within the same range, Range 3. Try adding your two COUNTS together... one for "conceptual" and one for "complete".

COUNTIFS({Interdependencies and impacts register Range 2}, "CSOD", {Interdependencies and impacts register Range 4}, "CFCD", {Interdependencies and impacts register Range 3}, "conceptual")

COUNTIFS({Interdependencies and impacts register Range 2}, "CSOD", {Interdependencies and impacts register Range 4}, "CFCD", {Interdependencies and impacts register Range 3}, "complete")

Full Formula:

=COUNTIFS({Interdependencies and impacts register Range 2}, "CSOD", {Interdependencies and impacts register Range 4}, "CFCD", {Interdependencies and impacts register Range 3}, "conceptual") + COUNTIFS({Interdependencies and impacts register Range 2}, "CSOD", {Interdependencies and impacts register Range 4}, "CFCD", {Interdependencies and impacts register Range 3}, "complete")

Let me know if that works!

Cheers,

Genevieve

All comments

Genevieve P.

Hi Phil,

The reason it's not working is that you're looking for two criteria separately within the same range, Range 3. Try adding your two COUNTS together... one for "conceptual" and one for "complete".

COUNTIFS({Interdependencies and impacts register Range 2}, "CSOD", {Interdependencies and impacts register Range 4}, "CFCD", {Interdependencies and impacts register Range 3}, "conceptual")

COUNTIFS({Interdependencies and impacts register Range 2}, "CSOD", {Interdependencies and impacts register Range 4}, "CFCD", {Interdependencies and impacts register Range 3}, "complete")

Full Formula:

Let me know if that works!

Cheers,

Genevieve

Phil Wightman

Hi @Genevieve P , thank you so much for taking the time to look at this. You fixed it! Yeah and happy Friday wherever in the world you are.

Genevieve P.

Hi Phil,

Great! I'm happy to help. Hope you're having a good weekend!

Genevieve

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.