Including FIND in COUNTIF
I would like to use COUNTIFS when two conditions are true
- The value in College = "ED"
- The text [Development Category] contains the word "Build".
EXAMPLES THAT COUNT:
College = "ED", [Development Category] = "Build OL only"
College = "ED", [Development Category] = "Build BL only"
EXAMPLES NOT TO COUNT:
College = "ED", [Development Category] = "Major rebuild"
College = "PS", [Development Category] = "Minor rebuild"
The formula would count all instances within a range (say rows 1 to 10):
=COUNTIF(College$1:College$10, "ED", [Development Category]$1:[Development Category]$10, FIND("Build", [Development Category](@cell))>1)
I'm getting a #UNPARSEABLE error, which I am sure has to do with the FIND part of the formula. It should look at the text in [Development Category], and if the text contains the word "Build" (i.e., FIND value is greater than 1), AND value of College = "ED", it should add an instance.
I am not sure if this is possible, and them I am not sure if I am evaluating the text in the [Development Category] correctly.
Thanks!
Comments
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!