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
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!