Question

in cell d16, enter a formula using a counting function to count the number of blank cells in the billable? column (cells d2:d14).

Explanation:

Step1: Use the COUNTBLANK function

The COUNTBLANK function in Excel is used to count the number of blank cells in a range. The syntax is =COUNTBLANK(range).

Step2: Enter the range

The range given is D2:D14. So the formula will be =COUNTBLANK(D2:D14)

Answer:

=COUNTBLANK(D2:D14)