SUMPRODUCT sum until condition changes

[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

 

[Ms-Exl-Learner]

Can you provide some sample data and your sumproduct formula.