View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rich Rich is offline
external usenet poster
 
Posts: 298
Default 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