COUNTIFS + FIND function help
Options
Sean_H
✭✭✭
Hello!
I am trying to count the number of rows with a nonblank cell in one column and a blank cell in another column. The nonblank cell contains a contract number that looks like 18A001SH 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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!