Countifs + Contains or Find Formula Help

I require assistance please to create a formula based on two criteria:

COUNT "SPI Quoted Value" column, when >0

and when

"Date" column CONTAINS or FIND "January"

Therefore if I only selected the first six rows as example, the SPI Quantity cell would return the value of 4.

I tried this formula, however didn't work =COUNTIFS([SPI Quoted Value]2:[SPI Quoted Value]7, >0, FIND("January", Date2:Date7))

Thanks Peta


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!