Add range reference to existing formula

[nostradamus]

Hello all,
I need help adding a range reference based on date and number of days preceding the selected date to an already developed formula

1. Formulas are developed in cells I2 and I3
2. Please develop formula for cell I4 with similar range reference as above (count the number of consecutive flow switches in col.C [positive to negative or negative to positive] with value greater than 4)

Below is a snippet of my data
Really appreciate any suggestions.

Sheet1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Date	Flow	DeltaFlow	Log10 Flow	Log10 DeltaFlow		days	Selected Dates	Results
2	10/30/2015	37900		4.57864			30	11/3/2015	1
3	10/31/2015	61600	23700	4.78958	0.21094		30	11/3/2015	2370000
4	11/1/2015	57700	-3900	4.76118	-0.02840		30	11/3/2015	1	=count number of sign ("+", "-") differences between the preceeding day in col.C
5	11/2/2015	10700	-47000	4.02938	-0.73179
6	11/3/2015	4070	-6630	3.60959	-0.41979
7	11/4/2015	6000	1930	3.77815	0.16856
8	11/5/2015	6500	500	3.81291	0.03476
Sheet1

Cell Formulas
Range	Formula
D2:D8	D2	=LOG10(B2)
C3:C8,E3:E8	C3	=B3-B2
I2	I2	=MAX(FREQUENCY(IF(C3:C6>-0.99,ROW(C3:C6)),IF(C3:C6<=-0.99,ROW(C3:C6))))
I3	I3	=AVERAGE(IF(C3:C6>0,C3:C6,""))*100