count(if

  1. N

    Count negative and some positive values

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

Some videos you may like

This Week's Hot Topics

Top