Auto filter and sum up data

[Ryan_Bernal]

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]

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)

:cheers:

[Ryan_Bernal]

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)

:cheers:
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]

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),"")

:cheers:

[LalitPandey87]

If you want to extract unique value using formula, find below link

List unique values using formula (http://www.excelfox.com/forum/f2/list-unique-values-using-formula-278/)

Enjoy.

[Ryan_Bernal]

Didn't work on me. :(
I dont know why.

[LalitPandey87]

PFA

547