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 I means full price) 'D' indicates price that customer pay. The example spreadsheet below is not the complete list and simply shows different categories.

	A	B	C	D
1	Customer Name	Customer Category	Payment category	Price (Rs)
2	Raman	Child	0	0
3	Dinesh	Adult	1	5
4	Jashan	Adult	0	2
:	:	:	:	:
101	Amit	Child	0	0

 

 

 

 

 

 

 

 

which of the following formula correctly counts all customers who are adults and get discounted price?

The correct formula to count all customers who are adults and get a discounted price is: =COUNTIFS(B2:B101, "=Adult", C2:C101, "=0")

Important Points To count the number of customers who are adults and receive a discounted price, follow these steps:

• Look at columns B and C in the table.
  • In column B, you'll find the customer category (e.g., Child or Adult), and in column C, you'll find the payment category (0 for discounted price or 1 for full price).
• We want to count only the customers who are adults (not children) and who receive a discounted price (payment category = 0).
• To do this, we can use the COUNTIFS function in Excel. It allows us to specify multiple criteria for counting.
•  In the formula, we need to specify the range of cells for the customer category (column B) and the payment category (column C).
•  The formula should look like this:

   ```
   =COUNTIFS(B2:B101, "Adult", C2:C101, 0)

   Here's what each part of the formula does:

•    - `B2:B101`: This is the range of cells in column B where we want to check for the customer category "Adult".
•    - `"Adult"`: This is the criteria we want to match in column B. We put it in double quotes because it's text.
•    - `C2:C101`: This is the range of cells in column C where we want to check for the payment category of 0 (discounted price).
•    - `0`: This is the criteria we want to match in column C. We don't use double quotes because it's a number.

 thus The correct formula to count all customers who are adults and get a discounted price is: =COUNTIFS(B2:B101, "=Adult", C2:C101, "=0")