COUNTIFS with multiple/variable criterion
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
-
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
Answers
-
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
-
Fantastic, works perfect thanks so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!