Separate multi values

[ali husain]

Hello all,

I have many numbers in sheet1 and I want to separate by store rooms and qty. please find attached sample sheet for more details. Hope somebody understand what I am looking for 

Thank you for your help.

[NBVC]

First fill in the 1458 in I3:I5 so that all cells are complete...

then in K2 use formula: =SUMPRODUCT(--($A$2:$A$30=I2),--($B$2:$B$30=J2),$C$2:$C$30)

copied down.

Adjust ranges to suit larger dataset if necessary