COUNTIF Question

[gymwrecker]

I have several cells with negative numbers, and others with positive numbers. I need to count all those that are positive, all the negative, and the empty ones, each one separate.

A1: -677
B1: -12
C1: 567
D1: -46

Can anyone assist with a formula to count them?

 

[VoG]

Try like this

Excel Workbook
	A	B	C	D	E	F
1	-2		9	7	Pos	2
2					Neg	1
3					Blank	1
Sheet1

 

[gymwrecker]

Thanks a lot Vog!!!