SUM from first positive number and on

[vmatis]

I have a range of numbers in a row that consist of both positive and negative numbers. I would like excel to locate the first positive number and start adding all the number then after including that first positive number. Does anybody have a solution for me.



-$7,514,205,-$91,005, -$91,005, -$91,005, $4,301,111, -$70,045
,-$70,045, -$70,045, $5,059,955, -$49,085, -$49,085, -$49,085,

,$5,460,915

Thanks

 

[shg]

Maybe this, which MUST be confirmed with Ctrl+Shif+Enter:

=SUM(INDEX(1:1, MATCH(TRUE, 1:1>0, 0)):INDEX(1:1, MATCH(9E+307,1:1 )))

 

[vmatis]

I just tried it and it did the trick. Thanks a lot!

 

[shg]

Go us!

You're welcome.