Sum values when filtered

**dbalam** · 12-01-2012, 01:14 PM

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

**Norie** · 12-01-2012, 01:16 PM

You could probably do this without filtering by using SUMIF or a pivot table.

**jeffreybrown** · 12-01-2012, 01:21 PM

Norie's suggestions are right on point, but if you want to filter column A and then total the sum in column B on the item filtered by...

You could use >> =SUBTOTAL(109,B2:B11)