SUMPRODUCT sum until condition changes

  • Thread starter Thread starter alexcn
  • Start date Start date
A

alexcn

Hi there,

I am trying to sumproduct across multiple dimensions, one of which I
need to have a condition summed until such time as the value changes
WITHIN the formula. So basically as one of the dimensions keeps on
increasing, the dimension should return TRUE, but once it stops
increasing / starts decreasing, then stop the sum.

Thanks,

Alex
 
Back
Top