Using Excel 2010
Hello,
I am using following to get results + & - value In the Column “C” using the formula given by Peter under this link……
www.mrexcel.com
I would like to count how many times after the each max negative value like, for example after -1,-2-3 and so on positive value “1” has appeared. Here below is the example sheet in which I need a count formula in the column “F”
Note: my request if I could be possible, I can use the given formula in the excel 2000 also.
Please help
Thank you all.
Regards,
Moti
Hello,
I am using following to get results + & - value In the Column “C” using the formula given by Peter under this link……
Formula Sum Positives If not start sum Negative
Using Excel 2010 Hello, I got results in the columns “G”, in the column “E” there is formula which drive result from Column “G” In the column “C” I have set formula which sum if value in the column “G” is >”” But I am not able to set the formula if column =”” get negative values sum as shown...
I would like to count how many times after the each max negative value like, for example after -1,-2-3 and so on positive value “1” has appeared. Here below is the example sheet in which I need a count formula in the column “F”
Note: my request if I could be possible, I can use the given formula in the excel 2000 also.
| MrExcel Question.xlsx | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | |||||||||
| 2 | |||||||||
| 3 | |||||||||
| 4 | Formula Require | ||||||||
| 5 | Result | - Values | Count 1 After - Value | ||||||
| 6 | -1 | -1 | 3 | ||||||
| 7 | 1 | -2 | 5 | ||||||
| 8 | 2 | -3 | 1 | ||||||
| 9 | -1 | -4 | 1 | ||||||
| 10 | -2 | -5 | 1 | ||||||
| 11 | -3 | -6 | 1 | ||||||
| 12 | -4 | -7 | 1 | ||||||
| 13 | 1 | -8 | |||||||
| 14 | 2 | -9 | |||||||
| 15 | 3 | -10 | |||||||
| 16 | -1 | -11 | |||||||
| 17 | -2 | -12 | |||||||
| 18 | 1 | -13 | |||||||
| 19 | -1 | -14 | |||||||
| 20 | -2 | -15 | |||||||
| 21 | -3 | -16 | |||||||
| 22 | -4 | -17 | |||||||
| 23 | -5 | ||||||||
| 24 | -6 | ||||||||
| 25 | 1 | ||||||||
| 26 | -1 | ||||||||
| 27 | -2 | ||||||||
| 28 | 1 | ||||||||
| 29 | -1 | ||||||||
| 30 | -2 | ||||||||
| 31 | 1 | ||||||||
| 32 | 2 | ||||||||
| 33 | -1 | ||||||||
| 34 | -2 | ||||||||
| 35 | -3 | ||||||||
| 36 | -4 | ||||||||
| 37 | -5 | ||||||||
| 38 | 1 | ||||||||
| 39 | -1 | ||||||||
| 40 | 1 | ||||||||
| 41 | -1 | ||||||||
| 42 | -2 | ||||||||
| 43 | 1 | ||||||||
| 44 | 2 | ||||||||
| 45 | -1 | ||||||||
| 46 | -2 | ||||||||
| 47 | -3 | ||||||||
| 48 | 1 | ||||||||
| 49 | 2 | ||||||||
| 50 | -1 | ||||||||
| 51 | -2 | ||||||||
| 52 | 1 | ||||||||
| 53 | 2 | ||||||||
| 54 | 3 | ||||||||
| 55 | -1 | ||||||||
| 56 | 1 | ||||||||
| 57 | -1 | ||||||||
| 58 | -2 | ||||||||
| 59 | -3 | ||||||||
| 60 | -4 | ||||||||
| 61 | -5 | ||||||||
| 62 | -6 | ||||||||
| 63 | -7 | ||||||||
| 64 | -8 | ||||||||
| 65 | -9 | ||||||||
| 66 | -10 | ||||||||
| 67 | -11 | ||||||||
| 68 | -12 | ||||||||
| 69 | -13 | ||||||||
| 70 | -14 | ||||||||
| 71 | -15 | ||||||||
| 72 | 1 | ||||||||
| 73 | -1 | ||||||||
| 74 | |||||||||
| 75 | |||||||||
| 76 | |||||||||
Sheet3 | |||||||||
Please help
Thank you all.
Regards,
Moti
