In the following MS-EXCEL spreadsheet you are given a list of 100 customers. Column ‘A’ represents their names, ‘B’ is for customer category, ‘C’ for payment category (0 Means discounted price and 1 means full price), ‘D’ indicates price that customer pay. The example spreadsheet below is not the complete list and simply shown different categories.


Statement I: The formula = COUNTIFS (C2:C101, “0”) counts all customers who get discounted price.
Statement II: The formula = COUNTIF (C2:C101, “=0”) Counts all customers who get discounted price.
In the light of the above statement, choose the correct answer from the options given below:

Correct option is A

Given Data:
• Column A: Customer Name
• Column B: Customer Category
• Column C: Payment Category (0 means discounted price, 1 means full price)
• Column D: Price that the customer pays
Statements:
• Statement I: The formula = COUNTIFS (C2:C101,"0")’ counts all customers who get discounted price.
• Statement II: The formula = COUNTIF (C2:C101, "=0") counts all customers who get discounted price.
Analysis:
Statement I: Formula: COUNTIFS (C2:C101, "0")
• COUNTIFS function is used to count the number of cells that meet multiple criteria. However, in this case, there is only one criterion.
• The formula will count the number of cells in the range C2:C101 that contain the value 0, which corresponds to customers who received a discounted price.
• Conclusion: This statement is correct because the formula accurately counts the customers with a discounted price.
Statement II: Formula: COUNTIF (C2:C101, "=0")
• COUNTIF function is used to count the number of cells that meet a single criterion.
• The formula will count the number of cells in the range C2:C101 that are equal to 0, which also corresponds to customers who received a discounted price.
• Conclusion: This statement is correct because the formula accurately counts the customers with a discounted price.