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?
1
=COUNTIF (B2:B101, "=Adult", C2:C101, "=0")
2
=COUNTIF (B2:B101, =Adult, C2 : C101, "=0")
3
=COUNTIFS (B2:B101, "=Adult", C2: C101, "=0")
4
=COUNTIFS (B2:B101, "=0", C2:C101,"=Adult")