First one works, but not the second one. Perhaps I haven't explained myself
well. Please see further post in reply to myself.

"Frank Kabel" wrote:

Hi Connie
1. Try
=COUNTIF(L17:L33,"<=-4")

2. Try
=COUNTIF(L17:L33,"=-4")-COUNTIF(L17:L33,"0")


--
Regards
Frank Kabel
Frankfurt, Germany


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