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.

	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 would indicate the total amount paid by customers who are adults but do not get discounted price?