Calculation Help

Anthoni

I want to count the number of cells with a combination of Red and Blue (from the drop-down). The answer should return the count of two. Can anyone support me with a potential calculation?

Thank you in advance.

SteyJ

https://community.smartsheet.com/discussion/117878/calculation-help

Just to verify, the count needs to have both red and blue to count? If this is the case, I believe the count would be only 2 based on the data provided

Anthoni

Hello Jacob,

Yes, you are correct. The answer should be 2 based on the data set I provided.

Thank you.

SteyJ

=COUNTIFS(colors:colors, AND(CONTAINS("red", @cell), CONTAINS("blue", @cell)))

Let me know if this works!