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)
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)
Posting Permissions
Reply With Quote
Bookmarks