count only if negative

  1. S

    How to use count formula if number is below zero or negative only

    I have the overnite change in dollars of a stock sybol in column (A) (for $0.54 or if opens lower -0.74). I want to do a kind of countif formula that counts the occurances of how many time it opens at a lower number then the previous day. In other words countif in column (A) it is a negative...

Some videos you may like

This Week's Hot Topics