In an MS Excel spreadsheet of 100 customers, column B is customer category, column C is payment category (0 means discounted price and 1 means full price) and column D is the price the customer pays. Which of the following formulas correctly counts all customers who are adults and get a discounted price?
A=COUNTIF(B2:B101, "=Adult", C2:C101, "=0")
B=COUNTIF(B2:B101, =Adult, C2:C101, "=0")
C=COUNTIFS(B2:B101, "=Adult", C2:C101, "=0") ✓ Correct
D=COUNTIFS(B2:B101, "=0", C2:C101, "=Adult")
Correct answer: (C) =COUNTIFS(B2:B101, "=Adult", C2:C101, "=0")
Explanation
COUNTIFS counts rows in B2:B101 that are Adult and, in C2:C101, carry the discount code 0.
COUNTIFS is needed because two separate conditions must both be met at once.
A plain COUNTIF handles only one condition, so it cannot test category and payment together.
Criteria must be written inside quotes, so =Adult without them would fail.
A form that puts the discount code and the Adult label in the wrong ranges mismatches the columns.
The value 0 flags discounted customers, while 1 flags those paying full price.
Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.
Practise on Mcqkart →🎓 Book an expert →