Formula question

akantemirova

I am struggling with the formula. I need to pull the info from all the cells that contain the "ITEM" and give me the total number. Some cells have multiple items, so when i use the COUNTIFS formula it does not pull the info from the cells with multiple items in it. What formula should I use? I need to take into account e.g. ITEM and COLOR.

Kelly Moore

Hey @akantemirova

Multiselect columns often need the HAS or CONTAINS function to read all the values within these cells.

Try this

=COUNTIFS(whatever range you are using, CONTAINS("ITEM", @cell))

be sure to replace my <range> with your real range.

Does this work for you?

Kelly

akantemirova

@Kelly Moore

Hello Kelly. Thank you for the response.

Here is what I have

=COUNTIFS({Feature Requests Range 1}, CONTAINS("APAC"@cell), {Feature Requests Range 2}, [Product Priority Level]@row)

However, it does not work. First I put the range, which is a column, then CONTAINS("APAC"@cell). APAC is the item i need searched for in the cells of the column

Thank you