Countifs + Contains or Find Formula Help

Peta

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

Jayesh Nathani

Hi Peta,

You were almost correct, try below:

=COUNTIFS(Date:Date, FIND("January", @cell) > 0, [SPI Quoted Value]:[SPI Quoted Value], >0)

Peta

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?

Jayesh Nathani

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))