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.
|