Number of Stocks with Positive Values (COUNTIF)

Number of Stocks with Positive Values

Sn Stocks Profit

1 Stock 1 8910

2 Stock 2 -9975

3 Stock 3 8189

4 Stock 4 4402

5 Stock 5 -4308

6 Stock 6 6795

7 Stock 7 3688

8 Stock 8 7467

9 Stock 9 -9500

Number of stocks with positive values

F13=COUNTIF(F4:F12;”>0″)

6

Number of stocks with negative values

F14=COUNTIF(F4:F12;”<0″)

3

#excel_tips #softexperia