Auto filter and sum up data

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:

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:

Quote:

---

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)

: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?

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:

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

List unique values using formula

Enjoy.

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

PFA

Attachment 547