If the number in column A = negative, I want to count the number of negative occurances in a row starting with column A.
-1% 1% -1% 0% 0% -2% -3% -6% -3% -1% -1% 1% -1% = 1
-1% -1% 0% 0% -2% -3% -6% -3% -1% -1% 1% -1% = 2
If the number in column A = negative, I want to count the number of negative occurances in a row starting with column A.
-1% 1% -1% 0% 0% -2% -3% -6% -3% -1% -1% 1% -1% = 1
-1% -1% 0% 0% -2% -3% -6% -3% -1% -1% 1% -1% = 2
=countif() or =sumif()
=countif(range,"<0")
=sumif(range,"<0")
those formulas count the number of negatives in a range. I'm looking to count negative cells in a series if column A is negative.
so in line 1 of the below example, the negative values in a series would be 1.
Last edited by Scorpvin; 10-15-2019 at 02:56 PM.
I am confused.so in line 1 of the below example, the negative values in a series would be 1.
So why does the 'Result' column show "=3"?
Please walk us through how you are arriving at the numbers you do.
Dave
the count equals 3 because A2, B2, C3 are negative. Cell D4 is positive so the count should end there.
Okay.
Try array entering this in cell I2 and filling down.
If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Formula:Please Login or Register to view this content.
This is shorter and simpler and also does not have to be array entered.Formula:Please Login or Register to view this content.
Even shorter
=IF(A2="","",MATCH(TRUE,INDEX(A2:H2>=0,),)-1)
@ Root_
Yup. Good one.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks