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.