|
|
First one is okay, second one not okay. Please see further post to myself,
explaining perhaps a little better.
Connie
"Don Guillett" wrote:
1. =sumproduct((l17:l33=-4)*(l17:l33<0))
2. countif<0
--
Don Guillett
SalesAid Software
"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
|