COUNTIFS + FIND function help
Sean_H
✭✭✭
Hello!
I am trying to count the number of rows with a non-blank cell in one column and a blank cell in another column. The non-blank cell contains a contract number that looks like 18-A-001-SH and everything but the leading 18 changes from one row to the next.
I started with this formula but it is returning a value of zero
=COUNTIFS({FY 18 Contract Number Range 3}, FIND("18", {FY 18 Contract Number Range 3}) = 1, {FY 18 Total Cost Range 1}, "")
Thanks in advance for any help,
Sean
Tags:
Comments
-
Perhaps I was searching twice because this is what worked
=COUNTIFS({FY 18 Contract Number Range 3}, CONTAINS(18, @cell), {FY 18 Total Cost Range 1}, "")
Thank you very much for your help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!