sum consecutive rows and count

[jlg1]

I have multiple rows of data. In column "C" there is a maximum value of 1000. If "C" does not equal 1000 then the sum of either two, three or four consecutive rows in "C" will equal 1000. I want a formula to tell me how many consecutive rows when taking the sum of "C" equals 1000, giving the answer (1,2,3 or 4) in column "D". Is this possible? Thanks in advance.

 

[Robert Mika]

Try soemething like this:

Excel Workbook
	C	D
1	100	4
2	200
3	300
4	400
5	1000	1
6	200	3
7	300
8	500
9	1000	1
10	200	3
11	300
12	500
13	1000	1
14	200	2
15	800
16	100
17	200	3
18	300
19	500
Sheet1

 

[jlg1]

Amazing, thank you so much!

 

[Robert Mika]

Just to mention that the 100 in row 16 shoudl be 1000 so you will get 1 in D16.