Formula to count positive and negative numbers

[PhilipeC]

I would like a formula to count positive numbers from H4:H20, such as if H4=100,H5=20,H6=10 than 100 and 20 = 2 count.


And another formula to count , negative numbers from H4:H20.

 

[mrhstn]

Hi

So greater than zero and then less than zero... right?

Book1
	H	I	J
4	14	12	Positive
5	20	5	Negative
6	16
7	8
8	19
9	14
10	-7
11	12
12	-12
13	3
14	13
15	-7
16	-15
17	-1
18	8
19	16
20	9
Sheet4

Cell Formulas
Range	Formula
I4	=COUNTIF(H4:H20, ">0")
I5	=COUNTIF(H4:H20, "<0")

 

[PhilipeC]

Thank you