how to add consecutive positive numbers

[shreen_farhad]

Hi,

I have an urgent question:

say i have the following data:

a1 = -1, a2 = 0, a3 = -2, a4 = 1, a5 = 2, a6 = -1, a7 = -2, a8 = 5, a9 = -1, a10 = 1

I want to add the first consecutive positive numbers. How do I write a formula for it?

What I want Excel to do is to go through this and add a4 and a5, that is it. Those are the first cosecutive numbers that appear in the data set.

[Cutter]

Try this in B2 and copy down:

=IF(AND(MAX(B$1:B1)=0,MIN(A1:A2)>0,A2=A1+1),A1+A2,"")