UGC NET ICT Q32

Question

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 pays. The example spreadsheet below is not the actual list and simply shows different categories.

Which of the following formula would indicate the total amount paid by customers who are adults but do not get discounted price?

Accepted Answer

= SUMIFS (D2: D101, B2: B101, "Adult", C2: C101, "=1")