Finding and Adding
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
|