Formula countifs mulitiple criterion?

Kimbh

Hi, I can get as far as (made up example) =COUNTIFS({Range 6}, "bdgl-1", {Range 5}, "pass") but I need to get a third items to be count. For example: =COUNTIFS({Range 6}, "bdgl-1", {Range 5}, "pass", {Range 8}, "ready") Is it possible to search three different columns in a crossheet countifs?

Thank you, I appreciate any help.

Kim

Kelly Moore

Hey @Kimbh

Yes, 3(or any number) columns within the same cross sheet can be included in criteria. Your formula looks as if it's ready to go. Did it work for you?

Kelly

Kimbh

Hi, it works today, no clue why it would not yesterday. I had to have something wrong.

Andrée Starå

Hi @Kimbh

I hope you're well and safe!

Excellent! Glad you got it working!

Be safe, and have a fantastic day!

Best,

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

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!