Countifs with Check mark

Hello,

I am trying to use the countifs formula to return calculated value based on status of progress and if client field is checked. Below is the formula I am using, however receiving the #unparseable error. Any idea?

The formula works when i have only one condition, however its returning the error when I add the client checkmark column in the equation.

=COUNTIFS(Status:Status, [Task Name]3),([Client]:[Client],=1)

Find more posts tagged with

Accepted answers

All comments

JamesB

@Mkaur

Just need to move your parentheses. You are closing your COUNTIFS statement before your second criterion.

=COUNTIFS(Status:Status, =[Task Name]3, Client:Client, =1)

Mkaur

@JamesB I tried plugging in the formula you recommended and unfortunately still receiving the same error. Feel like i am missing something else. Any additional suggestion?

Basically i am wanting to count all the task that are " Not Started (task3)" & have a check mark.

=COUNTIFS(Status7:Status118, [Task Name]3, Client: Client,=1)

JamesB

@Mkaur

Please see the attached below. If you are specifically looking for not started, you can use "Not Started" as a lookup value.

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.