First one is okay. The other two don't give the right answer.
"Bernie Deitrick" wrote:
Connie,
1:
=IF(COUNT(L17:L33)=0,"",COUNTIF(L17:L33,"-4"))
or possibly
=IF(COUNT(L17:L33)=0,"",COUNTIF(L17:L33,"<-4"))
depending if by "greater than" you mean on absolute or actual values.
2
=IF(COUNT(L17:L33)=0,"",COUNTIF(L17:L33,"-4")+COUNTIF(L17:L33,"-"))
HTH,
Bernie
MS Excel MVP
"Connie Martin" wrote in message
...
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
|