COUNTIFS with multiple/variable criterion

Jaime Holder

Hello all - I have a reference column called "process" which used to only have WELD, but now has WELDBEAM, WELDFRAME, WELDCUSTOM, etc.

My normal COUNTIFS worked flawlessly, but now i need to count 6 different sub-types.

I need a COUNTIFS function that will still count and combine any that match WELD.

All my searches came up short/functions that wouldn't work.

My current/previous formula is =COUNTIFS({process}, "weld", {month}, [MONTH#]@row)

My question is how do i write this to include the now 6 different sub-types of weld? i.e.,

=COUNTIFS({process}, "WELDBEAM" and "WELDFRAME" and "WELDFRAMELG" and "WELDCUSTOM"...etc.

I need a total of weld items, no matter the sub-type from a COUNTIFS statement - TIA for your help!

Leibel S

@Jaime Holder

Try this:

=COUNTIFS({process}, CONTAINS(@cell, "WELDBEAM WELDFRAME WELDFRAMELG WELDCUSTOM"), {month}, [MONTH#]@row)

Add to the string any additional options you want to look for

Leibel S

@Jaime Holder

Try this:

=COUNTIFS({process}, CONTAINS(@cell, "WELDBEAM WELDFRAME WELDFRAMELG WELDCUSTOM"), {month}, [MONTH#]@row)

Add to the string any additional options you want to look for

Jaime Holder

Fantastic, works perfect thanks so much!