CountIFs with FIND
Below formula is showing incorrect argument set.
=COUNTIFS(Name3:Name356, "", [Position Title]3:[Position Title]356, "Billing Specialist", [Req Status]3:[Req Status]356, "Open", [Dept Name & Cost Center]3:[Dept Name & Cost Center]355, FIND("10", @cell) > 0)
Tying to count rows that is blank in the Name column, with position title "Billing Specialist", Requisition status has to be open and Dept name and Cost center contains the text "10-". (e.g 10-5423)
Please advise. Thanks!
Comments
-
Hi styless,
You have an incorrect argument set because the column arguments for Dept Name & Cost Center does not match the other column arguments. All other column arguments go from row 3 to 356, whereas your argument for Dept Name & Cost Center goes from row 3 to 355. Change 355 to 356 and the formula will work.
Ps. Change your FIND("10", @cell) > 0 to FIND("10-", @cell) > 0 This will ensure that the result will only count cells that start exclusively with "10-"
I hope the above helps.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K 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!