Chen has a worksheet with a City column listing five cities and an Order ID column listing unique IDs for product orders.He wants to count the number of orders from Charlotte.Which of the following functions should he use?
A) SUMIF
B) AVERAGEIF
C) COUNTIF
D) IF

Question

Quizplus · Accepted Answer

COUNTIF is the correct function to use when you want to count the number of cells that meet a specific criterion, such as counting the number of orders from a specific city like Charlotte.

Chen Has a Worksheet with a City Column Listing Five