Auto filter and sum up data

**Ryan_Bernal** · 01-02-2013, 10:58 AM

Can someone help me on this?
I have 3 columns (Column A = Date,Column B = Area,Column C = Kg)
I want to automatically copy the filtered data on column I (Report) and get the total area and total kg of the the same data (area total column,kg total column) .

Here is the attached sample of my workbook:

**LalitPandey87** · 01-02-2013, 02:51 PM

Paste below formula in Cell J2 and drag it down :

=SUMIF($A$2:$A$23,$I2,$B$2:$B$23)

Paste below formula in Cell K2 and drag it down :

=SUMIF($A$2:$A$23,$I2,$C$2:$C$23)

**Ryan_Bernal** · 01-02-2013, 03:14 PM

Originally Posted by LalitPandey87

Paste below formula in Cell J2 and drag it down :

=SUMIF($A$2:$A$23,$I2,$B$2:$B$23)

Paste below formula in Cell K2 and drag it down :

=SUMIF($A$2:$A$23,$I2,$C$2:$C$23)

Thanks It works!
But how about column I?
Data in column A will be copy on Column I (not including the duplicates).
Any idea?

**LalitPandey87** · 01-02-2013, 04:00 PM

Paste below formula in Cell I2 with CSE and drag it

=IFERROR(INDEX($A$2:$A$23,MATCH(0,COUNTIF($I$1:I1, $A$2:$A$23),0)),"")

Paste below formula in Cell J2 and drag it down :

=IF($I2 <> "", SUMIF($A$2:$A$23,$I2,$B$2:$B$23),"")

Paste below formula in Cell K2 and drag it down :

=IF($I2 <> "", SUMIF($A$2:$A$23,$I2,$C$2:$C$23),"")