Countifs with Check mark

Mkaur

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)

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.