contains and CountIf formula

Nicole Martin

Good day, I want to the the following formula in my sheet summary.

I want to know how many enquiries there where in 2023 (The ref Number for 2023 Enquiries are "EC-xxx")

The REF colomn is an auto-number format.

I want to count the Ref column if it contains EC.

Please assist with this formula?

=COUNTIF(REF:REF; Contains(REF:REF;"EC) it says invalid

Kelly Moore

Hey @Nicole Martin

The @cell reference is used to tell a range (REF:REF in this case) to look at each cell and evaluate it.

=COUNTIFS(REF:REF, CONTAINS("EC", @cell))

Will this work for you?

Kelly

Nicole Martin

Thank you so Much!

How will the forumla work when I have multiple Ifs?

I would like to the the formula now when [=COUNTIFS(REF:REF, CONTAINS("EC", @cell))] and if the SUPPLIER column contains "LINX"?

=COUNTIFS(SUPPLIER:SUPPLIER; ="LINX"; (REF:REF; CONTAINS("ED"; @cell)))

Thank you for the assistance.

Andrée Starå

Hi @Nicole Martin

I hope you're well and safe!

Try something like this.

=COUNTIFS(SUPPLIER:SUPPLIER; "LINX"; REF:REF; CONTAINS("ED"; @cell))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!