CountIFS

JiMel

I want to count based on 4 criteria being met. My formula isn't given me an error, just a 0. However, I have 1 data point that is < than 3......i should have a 1 being returned not a 0.

Razetto

@JiMel Hi,have you tried adding the @cell reference? ...,{Paint.. Conc}, @cell<3,...

JiMel

Razetto, I haven't used that feature in the past....but i inserted it as shown. Still giving me a 0 vs the 1 I expected.

Leibel S

@JiMel

Your formula is saying that the Paint Line Stage value needs to be both less than 3 and more than 4. this will always return 0.

JiMel

Leibel, thank you....I inserted an OR in the formula and is now reporting properly.