Countifs

SALLY P

I have a dropdown list with multiple service items in text format, and I'm trying to count those text items. Seems easy but Countifs keeps giving me an error and I canot figure out why.

I have a separate metric sheet that includes the services I'm trying to count. Here is the formula

=COUNTIF({Survey Range 12}, CONTAINS([Services]@row))

Mark.poole

=COUNTIF({Survey Range 12}, CONTAINS(@cell,Services@row),{Survey Range 12})

JamesB

@SALLY P You need to complete the arguments for the Contains Formula.

I am assuming that Survey Range 12 is your multi select column on the referenced sheet. That being the case the below formula says count the items in {Survey Range 12" where "What to Search for" is in {Survey Range 12}. I hope this make sense.

=COUNTIF({Survey Range 12}, CONTAINS("What To Search for",{Survey Range 12}))

Matthew R

I was able to get this formula below to work, unsure if it is exactly what you are after though.

I used a HAS function instead of CONTAINS, and it would require to input the "Survey Item" manually in the quotations for each row.

Hope this helps a bit!

=COUNTIFS({Survey Range 12}, HAS(@cell, "Apple"))