Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to count the rows if the value of the column, from bottom up,
changes sign (from positive to negative or vise versa.). As soon as the sign is changed or the number is the value of a zero, counter finishes counter. For example, -2.1 31.2 -2.1 0.3 44.8 1.6 -1.1 -9.4 5.3 44 10.4 9 13.1 -2.2 0 12.2 -11.1 3.2 counter = 3 counter = 2 counter = 1 Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF | Excel Discussion (Misc queries) | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |