Multiple Criteria for Countif

Richard A · 08/04/23

Hi,

I am trying to set a criteria, which picks information from two seperate columns in the same sheet, Countif {NCR Owner} = "X" and {Source} = "X"

Thank you

Andrée Starå · 08/07/23

Hi @Richard A

I hope you're well and safe!

Try something like this.

=COUNTIFS({NCRs - Open Range 2}, "Matt Robins", {NCRs - Open Range 3}, "Customer")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome · 08/04/23

You are going to need a COUNTIFS (with the S on the end) to be able to include multiple range/criteria sets.

https://help.smartsheet.com/function/countifs

Richard A · 08/07/23

Sorry, yes I am using Countifs, but I still just can't get it to work:

=COUNTIFS([{NCRs - Open Range 2}]:[{NCRs - Open Range 2}], "Matt Robins", [{NCRs - Open Range 3}]:[{NCRs - Open Range 3}], "Customer")

Andrée Starå · 08/07/23

Hi @Richard A

I hope you're well and safe!

Try something like this.

=COUNTIFS({NCRs - Open Range 2}, "Matt Robins", {NCRs - Open Range 3}, "Customer")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå · 08/07/23

@Richard A

Your cross-sheet ranges were doubled and used square brackets too. (bolded)

=COUNTIFS([{NCRs - Open Range 2}]:[{NCRs - Open Range 2}], "Matt Robins", [{NCRs - Open Range 3}]:[{NCRs - Open Range 3}], "Customer")

Richard A · 08/07/23

https://community.smartsheet.com/discussion/comment/389133#Comment_389133

Hi Andree,

Fantastic - Thank you.

You stay safe too!

Best regards

Andrée Starå · 08/07/23

@Richard A

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Multiple Criteria for Countif

Best Answer

Answers

Help Article Resources

Categories