Questions about COUNT ??

[rs]

I have a column of figures that has both postivie and negative numbers.
-Is there a function that will tell me how many positive numbers there are and
how many negative numbers there are?
-Is there a function that will actually add only the positive numbers as a
sum and only the negative numbers as a sum?

thanks to all for the help . .

 

[Bob Phillips]

=COUNTIF(A:A,">0")

=COUNTIF(A:A,"<0")

=SUMIF(A:A,">0")

=SUMIF(A:A,"<0")

 

[Earl Kiosterud]

=WHATIF(A:A=0)?

 

[Bob Phillips]

You tell me whether 0 is a negative or a positive number, I know what I
think As positive and negative are defined in terms of zero, it is neither.