Question

In cell C12, enter a formula using a counting function to count the number of items in the Item column (cells C2:C11).

Answer 1

To count the number of items in the range C2:C11, use the formula =COUNTA(C2:C11) in cell C12, which counts non-blank cells.

Step-by-step explanation:

To count the number of items in the Item column from cells C2 to C11 in cell C12, you should use the COUNTA function which is designed to count non-blank cells within a specified range. Your formula in cell C12 should look like =COUNTA(C2:C11). This function will provide the total number of non-empty cells in the range, effectively giving you the number of items listed in the column.