View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Sum Postitive Values

Another one

=SUMPRODUCT((MOD(ROW(A18:A51),11)=7)*(A18:A510),A 18:A51)

If this post helps click Yes
---------------
Jacob Skaria


"crysallisa" wrote:

Please advise how should I set the formula.

I have few values over several rows (A18, A29, A40, A51), and in cell A54, I
want to sum up the above cells that are in positive values and to excludes
any values that are less than 0.