Most valuable professional
  • Hot Topics

Excel Calculating streaks when some cells are blank

I am trying to calculate winning and losing streaks, but some of my cells do not contain information because a team might not play on that current day. How can I have a formula that will over look a blank cell, but still have it continue a streak? Example Cell A1. W A2. L A3. W A4. A5. W A6. W I should have a streak of 3 wins, but every time I try a formula it will only calculate it as 2 wins. How do I have a formula overlook the blank cell? And then I need it to calculate the longest streak as well. Any and all help would be greatly appreciated Thank you, Tim

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

This thread is current as of August 10, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel