Good Morning,

How can I create a lookup to count consecutive numbers > 100%.

I have a sheet with columns of percentages for sales reps and would like to count consecutive quarters that they are over 100%.

Sales 1 109.4% 99.2% 96.3% 101.4% 90.2%
Sales 2 82.3% 78.0% 78.4% 83.3% 84.0%
Sales 3 98.2% 89.0% 98.8% 87.7% 83.0%
Sales 4 96.5% 91.5% 102.1% 96.8% 107.2%
Sales 5 108.7% 109.0% 97.6% 112.1% 102.3%
Sales 6 109.2% 116.1% 119.6% 114.8% 100.0%
Sales 7 100.4% 114.7% 107.9% 107.7% 93.1%

Assuming all information is in one sheet and there are 5 columns of figures. Thanks for the help.