Counting negative & positive numbers

[Connie]

I need a formula that will give me the total of negative
numbers (any number below zero) in a given column of
numbers, and then another formula giving me the number of
positive numbers (above zero). Zero will not be included
in either formula. Thank you in advance!

 

[Peo Sjoblom]

=SUMIF(Range,"<0")

and

=SUMIF(Range,">0")

or if you by total mean count

=COUNTIF(Range,"<0")

and so on

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Frank Kabel]

Hi
try
=COUNTIF(A:A,"<0")
and
=COUNTIF(A:A,">0")

 

[Don Guillett]

If you want to count all <>0
=COUNTIF(L1:L5,"<>"&0)

 

[Connie]

Thank you. That worked! I recognize your name---you have
helped me a few times. Thank you, Frank, from Connie in
Canada.

 

[Connie]

Thank you. The COUNTIF is the function I was looking for.