That formula gives the answer 3. It should be 11.

"Frank Kabel" wrote:

Hi
the '-' is just formated for the value zero?. If yes the following
formulas should work
=COUNTIF(A1:A20,"=-4")-COUNTIF(A1:A20,"0")

or
=SUMPRODUCT(--(A1:A20=-4),--(A1:A20<=0))

adapt the ranges to your needs


--
Regards
Frank Kabel
Frankfurt, Germany


Connie Martin wrote:
I get the right answer from the first formula you all gave, Bob,
Bernie & Frank. But the other formulas are not working. I will give
you the exact numbers in the column I'm working with now, where the
formula should yield 11: -
-
-
-
-
(1)
(1)
(1)
3
2
-
-
5
5
5
6
-

There are eight "-" and three numbers in the range of (4) to breaking
even (the "-").

Connie





"Connie Martin" wrote:

1. I have a formula I want to change and am not sure how.
=IF(COUNT(L17:L33)=0,"",COUNTIF(L17:L33,"<0"))
I want to now count all numbers from negative 4 and more. In case
I'm not explaining this properly, if the column as these negative
numbers (5), (3), (7), (8), (1), if would count only 3.

2. I have another formula that needs changing:
=IF(COUNT(L17:L33)="","",COUNTIF(L17:L33,"-"))
First of all, please note, the "-" is not text. It's the result of
breaking even in an accounting formatted column. Okay, what I need
changed is that it would count all numbers from negative 4 to the
breaking even point. Again, in case I'm not explaining myself
properly, if a column has these numbers: (4), (1), 8, 1, -, (2), it
will count 4 from this colum.

Thank you
Connie Martin