How to create a formula to count # of values in a multi-value cell + other criteria using COUNTIFS?
Hello, I'm trying to count a value from a multi-value cell considering more than one criteria located in other columns.
I'm trying using this formula: =COUNTIFS([LSP Name]:[LSP Name], CONTAINS("CNWQ", @cell), Active:Active, CONTAINS("Active", @cell), Function:Function, CONTAINS("MULTIPLE", @cell)) but is not working. Is not returning an error, but is not counting.
Thanks
Best Answer
-
Hi @PauSanHPE
Count ifs will return a result only if all the criteria you've in the formula is met. It is similar to AND. Does the LSP Name column contain the value CNWQ in at least one cell? If not, try adding it and you will get a result.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Answers
-
Try this: =COUNTIFS([LSP Name]:[LSP Name], HAS(@cell, "CNWQ"), Active:Active, "Active", Function:Function, "MULTIPLE")
-
Hi @PauSanHPE
Count ifs will return a result only if all the criteria you've in the formula is met. It is similar to AND. Does the LSP Name column contain the value CNWQ in at least one cell? If not, try adding it and you will get a result.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
Hello guys,
I just noted that I used the incorrect LSP Name, that is why it didn't return any value.
Thank you so much.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 429 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!