Using Countif to check for two sets of criteria in same row

AnthonyRing360

I need to compare that a range meets both of the following criteria:

1 - Range 1 includes a specific value contained in a different cell

2 - Values in Range 2 contain a string of text

My formula looks like this but isn't working

=COUNTIF({Unique Call Log Range 2}, CONTAINS("TEST1", @cell)) , ({Unique Call Log Range 1}, FieldName@row)

I can break it apart so that either of the criteria counts individually but when I try to make it so that it only counts when both criteria are met, it fails.

These two formulas work on their own

=COUNTIF({Unique Call Log Range 2}, CONTAINS("TEST1", @cell))

=COUNTIF({Unique Call Log Range 1}, FieldName18)

But I can't figure out the formula to only count if both criteria are met in the same row.

L_123

=COUNTIFS({Unique Call Log Range 2}, CONTAINS("TEST1", @cell),{Unique Call Log Range 1}, FieldName18)

Give that a try

L_123

https://help.smartsheet.com/function/countifs

AnthonyRing360

This isn't working - how do I use "contains" instead of exact match within this formula?

L_123

=COUNTIFS({Unique Call Log Range 2}, CONTAINS("TEST1", @cell),{Unique Call Log Range 1}, FieldName18)

Give that a try

AnthonyRing360

That worked! Thanks!