Conditional running total

[dmc6262]

Hi,

Appreciate any help here. I'm looking for a formula that searches a column and runs a count of positive numbers after the appearance of the last zero or negative number in that specific column. Essentially it's looking for a positive trend. If for example the current trend is 2 (2 positive numbers since the last 0 or negative number) it will reset to zero when a zero or negative number is next input as the data expands. I've manually completed an example below to illustrate:

	A	B	C
	3	0	2
	2	3	3
	0	3	14
	1	0	9
	3	4	-1
Trend at this point	2	1	0
New data input:	-6	5	3
Trend at this point	0	2	1

<tbody>
</tbody>

 

[Special-K99]

Put your trend results in columns D E and F (relating to columns A B and C respectively).

in D1 E1 F1 put 1

in D2
=IF(B2<=0,0,I1+1)
copy across and down the columns for however many rows there are in column A B and C