How can I count two sets of values in Excel. I am trying to count all values that are less than Zero plus columns with a value of ".55".
I have tried =Count(IF(SumRange1,"<0",IF(SumRange1,"0.55",SumRange1))).
I get a value if I only use <0 argument but If I add the "0.55" I do not get any...