COUNTIFS with multiple/variable criterion

Jaime Holder
Jaime Holder ✭✭✭
edited 02/15/24 in Formulas and Functions

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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!