Additional Info


  • Hot Topics

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 4, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel