Excel: Formula for Sum of Max Consecutive Negative Values D5:D29


Hi. I've done some research here but I'm afraid I haven't yet found the answer. I'm looking for a sum formula that will do these things: 1. SUM the largest streak of negative numbers in that range.(aka "max drawdown") 2. SUMthe largest streak of positive numbers in that range.(aka "max runup") and then these 2 simple Counts: 1) # of consecutive cells bearing the longest streak of neg #s 2) # of consecutive cells bearing the longest streak of positive #s No VBA or arrays if you don't mind. Just a formula like: =SUM (etc) I respect your time and experience. thankyou


This question generated 18 answers. To proceed to the answers, click here.

This thread is current as of January 04, 2015.


For more resources for Microsoft Excel