Here is my worksheet example. I need a formula to count how many times the 'Service Level %' was greater than 79.999% for each day of the week. So for Monday, there is two data points, but, 1 would be my answer in this example.
<tbody>
</tbody>
Weekday | Service Level % | Calls Offered | Work days |
Mon | 81% | 200 | 1 |
Tues | 73% | 100 | 1 |
Wed | 60% | 159 | 1 |
Thur | 90% | 232 | 1 |
Fri | 82% | 278 | 1 |
Mon | 64% | 132 | 1 |
Tue | 79% | 145 | 1 |
Wed | 89% | 200 | 1 |
<tbody>
</tbody>