Help to count a column where neither 'Complete' 'Canceled' checkboxes are selected

Hi all,

I am trying to build a formula that references another sheet, mostly focusing on 3 columns in that sheet:

At Risk (symbol) | Completed (checkbox) | Canceled (Checkbox)

I am trying to count all the values in the At Risk column where neither Completed or Canceled checkboxes are selected. Basically, I'm trying to count active projects that are at risk. I keep getting errors in every formula I try so I was wondering maybe someone could help get it working.

I thought I finally had it with this:

=IF(AND({Completed Checkbox}, 0, {Canceled checkbox}, 0), COUNTIF({At Risk}, "High"))

And then got a new error I hadn't gotten before #INVALID DATA TYPE

Can anyone help?

Find more posts tagged with

Formulas

Accepted answers

Julie Fortney

Try this formula:

=COUNTIFS({At Risk}, "Red", {Completed}, 0, {Canceled}, 0)

The logic is:

Count if all conditions are true (Range 1, Criterion 1, Range 2, Criterion 2, etc.)

I hope that helps!

All comments

Julie Fortney

Try this formula:

=COUNTIFS({At Risk}, "Red", {Completed}, 0, {Canceled}, 0)

The logic is:

Count if all conditions are true (Range 1, Criterion 1, Range 2, Criterion 2, etc.)

I hope that helps!

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.