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.