To count the number of times that the values in cell range B6:B15 exceed 5000 in the Annual Sales worksheet, you can use the COUNTIF function.
To count the number of times that the values in cell range B6:B15 exceed 5000, you can use the COUNTIF function in cell B17 of the Annual Sales worksheet. The syntax for the COUNTIF function is COUNTIF(range, criteria). In this case, the range is B6:B15 and the criteria is '>5000'.
The formula to use in cell B17 is =COUNTIF(B6:B15, '>5000'). This will count the number of values in the range B6:B15 that are greater than 5000.
For example, if there are 3 values in the range that exceed 5000, the result in cell B17 will be 3.