hi, I have requirement where we need to filter a column "Card Used" with a particular text then calculate the values from the corresponding columns and sum the values and display the result in column 'C'. I am giving you a sample structure.

Card Used Bill Amount
Citi_MasterCard $100.00
BoA_Visa $75.00
BoA_Visa $83.00
Amex $54.00
Citi_MasterCard $120.00
BoA_Visa $433.00
Citi_MasterCard $304.00
OrchardCard $12.00
Amex $234.00
Citi_MasterCard $79.00