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
Answers

Hi Peta,
You were almost correct, try below:
=COUNTIFS(Date:Date, FIND("January", @cell) > 0, [SPI Quoted Value]:[SPI Quoted Value], >0)

Hi Jayesh,
I'm getting a result of 0, instead of 4.
Where you have @cell, what am I typing in there; @cell or a particular cell?

Oh I'm sorry, I didn't see that your column had commas in it.
Try this 
=COUNTIFS(Date:Date, FIND("January", @cell) > 0, [SPI Quoted Value]:[SPI Quoted Value], OR(@cell <> "0", @cell <> 0))
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!