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
 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
Check out the Formula Handbook template!