First one is okay, but second one is not giving the right answer.
"Bob Phillips" wrote:
1.=IF(COUNT(L17:L33)=0,"",COUNTIF(L17:L33,"<-4"))
2. =IF(COUNT(L17:L33)="","",COUNTIF(L17:L33,"<0")-COUNTIF(L17:L33,"<-4"))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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
|