Sum of time for consecutive positive/ negative numbers

Hi Dex,

Suggest you to upload a sample workbook highlighting your expected output. Thanks.

Regards,

DILIPandey
<click on below * if this helps>

Dex, given urgency I suspect you have resolved elsewhere ?

You could probably do without helpers c/o a complex Frequency array, however, helpers are never a bad thing in my opinion.

What's not clear is what happens when you have >1 streaks of same longevity - presumably you would want to take the max duration of the various streaks ?

Below seems a little long winded but all formulae are efficient (no arrays, no volatiles etc) so performance should be good.

Formula:

Please Login or Register  to view this content.

at which point

Formula:

Please Login or Register  to view this content.

to reiterate - you could do the same with far fewer formulas than the above but if performance is of paramount concern then the above might be worthy of consideration.