Count if

Karrie Davis

Hi I'm wondering if someone could assist me. I writing a count if for a column and it isn't counting the item if there is more than one answer in a row. Example would be =Countif([Case Type]:[Case Type], ="Birth Certificate". If you see below where Birth Certificate and SSI are in the same row, my formula is not counting that Birth Certificate its is giving me answer of 3 instead of 4.

Malaina Hudson

Hi @kari1282 ,

Give this a try and see if it does what you need it to do.

=COUNTIF([case type]:[case type], CONTAINS([search criteria]@row, @cell))

When I tested, here's what I saw in the results.

Let me know if that works for you.

Karrie Davis

@Malaina Hudson

Thank you, I was placed the formula in sheet summary and it is showing as unpareseable

=COUNTIF([Case Type]:[Case Type], CONTAINS([Search Criteria] @row, @cell))

Malaina Hudson

@kari1282 , check to make sure you have 2 ) at the tail of the calculation. Also make sure that your form is set up like the example I showed with the search criteria column. This formula needs to reference search criteria to function with the result I demonstrated.

Karrie Davis

@Malaina Hudson

Hi Malaina, it works in the spreadsheet, however the formula does not work on sheet summary

Thank you for taking the time to work with me on this

Andrée Starå

Hi @kari1282

I hope you're well and safe!

To add to Malaina's excellent advice/answer.

Try this. (I've removed the @row part because it doesn't work in Sheet Summary)

=COUNTIF([Case Type]:[Case Type], CONTAINS([Search Criteria], @cell))

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 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!

Karrie Davis

@Andrée Starå Thank you for your help, however that did not work either.

Andrée Starå

@kari1282

Happy to help!

Sorry about that!

Try this.

=COUNTIF([Case Type]:[Case Type], CONTAINS("SearchCriteria", @cell))

Did that work?