COUNTIFS on multiple columns looking for multiple conditions.

jambla · 04/02/20

Hi,

Im trying to count how many rows fit a specific criteria.

Here is my example table:

In this example I want to count how many rows are assigned to "In House" with a Status of "In" and Difficulty of "A".

This is my formula:

=COUNTIFS([Assigned To]:[Assigned To], "In House", [Status]:[Status], “In”,[Difficulty]:[Difficulty], “A” )

When I do that I get #UNPARSEABLE

Any help would be much appreciated!

Andrée Starå · 04/02/20

Hi Jambla,

It seems like the [ ] Around the status part throws it off.

Try something like this.

=COUNTIFS([Assigned To]:[Assigned To]; "In House"; Status:Status; "In"; Difficulty:Difficulty; "A")

The same version but with the below changes for your and others convenience.

=COUNTIFS([Assigned To]:[Assigned To], "In House", Status:Status, "In", Difficulty:Difficulty, "A")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå · 04/02/20

Hi Jambla,

It seems like the [ ] Around the status part throws it off.

Try something like this.

=COUNTIFS([Assigned To]:[Assigned To]; "In House"; Status:Status; "In"; Difficulty:Difficulty; "A")

The same version but with the below changes for your and others convenience.

=COUNTIFS([Assigned To]:[Assigned To], "In House", Status:Status, "In", Difficulty:Difficulty, "A")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

jambla · 04/02/20

Worked perfectly! Thanks Andrée!

Andrée Starå · 04/02/20

Excellent!

Happy to help!

COUNTIFS on multiple columns looking for multiple conditions.

Best Answer

Answers

Help Article Resources

Categories