CountifS based on a multi select column

Mtmoroni

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

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?

Jeff Reisman

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)

Jeff Reisman

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)

Mtmoroni

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

Jeff Reisman

@Mtmoroni Happy I could help!

Vicki Diaper

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)