Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Tricky formulas needed | Excel Worksheet Functions | |||
A formula to check differrent cells | Excel Worksheet Functions |