Thread: Subrange
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
oscar oscar is offline
external usenet poster
 
Posts: 55
Default Subrange

In range a (part of the column) I have series of values. I want to calculate
sum of positive and negative increments. Formula
SUMPRODUCT(--(a-OFFSET(a,-1,0)<0),a-OFFSET(a,-1,0)) works O.K. apart from the
fact that I should skip first row. Instead of a I should calculate with
subrange of a - range a without a first row.

If anybody can help...

Thanks, Oscar.