SUM excel 2013

[docodao]

Hi all,

Please help me to sum quantity of style as follows:

2016-03-14.png

Thanks

[docodao]

I have this formula but it too long, please help me to minimize it

quote

=sumif('order (fpo)'!$e$4:$p$4,right(dm!d26,1),'order (fpo)'!$e$5:$p$5)*'order (fpo)'!$d5+sumif('order (fpo)'!$e$6:$p$6,right(dm!d26,1),'order (fpo)'!$e$7:$p$7)*'order (fpo)'!$d7+sumif('order (fpo)'!$e$8:$p$8,right(dm!d26,1),'order (fpo)'!$e$9:$p$9)*'order (fpo)'!$d9+sumif('order (fpo)'!$e$10:$p$10,right(dm!d26,1),'order (fpo)'!$e$11:$p$11)*'order (fpo)'!$d11+sumif('order (fpo)'!$e$12:$p$12,right(dm!d26,1),'order (fpo)'!$e$13:$p$13)*'order (fpo)'!$d13

unquote

thanks