Positive and negative cell count.

**Big Rick** · 05-01-2012, 02:05 PM

Hi. Folks

Looking for some formula help please.

Have a column (e5,e22) which will display either a postive number, a negative number, or a 0.

I would like a formula to count the total number of postive cells (but disregarding 0) and a formula counting the total number of negative cells (again disregarding zero).

Looking forward to your answer in anticipation.
Thanks for trying.
Big Rick

**tom1977** · 05-01-2012, 02:09 PM

try use countif function with <0 >0 and 0 as argument

**zbor** · 05-01-2012, 02:10 PM

Countif(E5:E22, ">0") and "<0"

**icestationzbra** · 05-01-2012, 02:11 PM

something like this?

=COUNTIF(E5:E22,"<0")

=COUNTIF(E5:E22,">0")

**Big Rick** · 05-01-2012, 02:28 PM

Many thanks to Zbor and Icestationzebra.

I was going wrong because I didn't think that the "<1" should be in quotes due to it being a value and not text.

Many thanks to Tom also.

Let me buy you all a virtual pint.