Thread: Formula needed
View Single Post
  #1   Report Post  
Connie Martin
 
Posts: n/a
Default Formula needed

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