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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!