Question

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

Explanation:

Step1: Use the COUNTA function

The COUNTA function in Excel counts the number of non - blank cells in a range. The syntax is =COUNTA(range).

Step2: Enter the formula

In cell D15, enter the formula =COUNTA(D2:D14).

Answer:

=COUNTA(D2:D14)