# CountifS based on a multi select column

✭✭✭✭✭

Basically, trying to calculate a count from another sheet.

If sale specifics has "Contract Renewal" in it, I want a value. The rest based on the month works fine, but I can't get it to count if it contains "contract renewal.

I'm unsure if CONTAINS would be a better formula?

Tags:

• ✭✭✭✭✭✭

Yes, CONTAINS would be the way to go. Since you're already specifying the range, give it the criteria of CONTAINS(value, @cell).

=COUNTIFS({CTC Business Sales Specifics}, CONTAINS("Contract Renewal", @cell), {CTC Business Sales Sold Month}, Month@row)

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭

Yes, CONTAINS would be the way to go. Since you're already specifying the range, give it the criteria of CONTAINS(value, @cell).

=COUNTIFS({CTC Business Sales Specifics}, CONTAINS("Contract Renewal", @cell), {CTC Business Sales Sold Month}, Month@row)

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭

THANK YOU! - I was trying to reference the same {CTC Business Sale Specifics} VS the "@cell".

• ✭✭✭✭✭✭

@Mtmoroni Happy I could help!

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• edited 03/08/22

This formula has been very useful for the data sheet that I am creating and have a follow-up question.

Use the same example formula, how would you amend the formula to include any values to count where historically "Contract Renewal" was titled as something else. Say "Account Renewal" or "Renewal"?

=COUNTIFS({CTC Business Sales Specifics}, CONTAINS("Contract Renewal", @cell), {CTC Business Sales Sold Month}, Month@row)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!