Using Countif to check for two sets of criteria in same row
I need to compare that a range meets both of the following criteria:
1 - Range 1 includes a specific value contained in a different cell
2 - Values in Range 2 contain a string of text
My formula looks like this but isn't working
=COUNTIF({Unique Call Log Range 2}, CONTAINS("TEST1", @cell)) , ({Unique Call Log Range 1}, FieldName@row)
I can break it apart so that either of the criteria counts individually but when I try to make it so that it only counts when both criteria are met, it fails.
These two formulas work on their own
=COUNTIF({Unique Call Log Range 2}, CONTAINS("TEST1", @cell))
=COUNTIF({Unique Call Log Range 1}, FieldName18)
But I can't figure out the formula to only count if both criteria are met in the same row.
Best Answer
-
=COUNTIFS({Unique Call Log Range 2}, CONTAINS("TEST1", @cell),{Unique Call Log Range 1}, FieldName18)
Give that a try
Answers
-
This isn't working - how do I use "contains" instead of exact match within this formula?
-
=COUNTIFS({Unique Call Log Range 2}, CONTAINS("TEST1", @cell),{Unique Call Log Range 1}, FieldName18)
Give that a try
-
That worked! Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!