Auto filter and sum up data

[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)

[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)

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]

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

List unique values using formula

Enjoy.

[Ryan_Bernal]

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