Using COUNTIFS and two CONTAINS

Tiffany Sablan

I've read most of the answers and using the recommendations, I'm still getting the error #UNPARSEABLE

This FORMULA works, but I need to add another search for "DC"

=COUNTIFS([DC - Status]:[DC - Status], "Incorrect DC") + COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("duplicate", @cell)))

so I've add another COUNTIFS and CONTAINS but it's giving me an error. Also, tried variations and neither works. This FORMULA is the one that returns #UNPARSEABLE:

=COUNTIFS([DC - Status]:[DC - Status], "Incorrect DC") + COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("duplicate", @cell))), + COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("dc", @cell)))

Any help would be greatly appreciated.

Thanks so much!

Toufong Vang

Looks like a syntax error. You have an unnecessary comma.

Try the corrected formula.

= COUNTIFS([DC - Status]:[DC - Status], "Incorrect DC") + 
  COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("duplicate", @cell))) + 
  COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("dc", @cell)))

Bassam Khalil

Hi @Tiffany Sablan 

Hope you are fine, please try the following formula ( and you can add as much as you need of the searching criteria in the Criteria column after you converting the formula to column format formula:

=IF(ISBLANK(Criteria@row), "", COUNTIFS([DC - Status]:[DC - Status], HAS(@cell, Criteria@row)))

the following screen shot shows the result

Bassam Khalil

Toufong Vang

Looks like a syntax error. You have an unnecessary comma.

Try the corrected formula.

= COUNTIFS([DC - Status]:[DC - Status], "Incorrect DC") + 
  COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("duplicate", @cell))) + 
  COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("dc", @cell)))

Bassam Khalil

Hi @Tiffany Sablan 

Hope you are fine, please try the following formula ( and you can add as much as you need of the searching criteria in the Criteria column after you converting the formula to column format formula:

=IF(ISBLANK(Criteria@row), "", COUNTIFS([DC - Status]:[DC - Status], HAS(@cell, Criteria@row)))

the following screen shot shows the result

Tiffany Sablan

@Toufong Vang Thank you so much! That did the trick. @Bassam Khalil I went with the original formula but this example was extremely helpful for another formula I was trying to solve. I appreciate both of your quick responses.

Bassam Khalil