Although not perfect given there could be all positive numbers something on
these lines would give you the result :

=SUM(OFFSET($A$1,MATCH(2,1/(--(A1:A70))),,ROW(A7))) array entered
(ctrl+shift+enter)


"Rich" wrote:

Hi,

Have a problem hopefully I can get some help with. I need a formula to find
the last positive number in a row and then add that and all the numbers that
come after it.

Example:

-10 100 -10 -20 60 -10 -20

I need the formula to locate the 60 and then add 60+(-10)+(-20)

Thanks in advance!

Rich