simplification of formula?

[Akakaboto]

Hello,

I would like to know if you can figure out an easier way to write below formula. Previuosly we have had a toolbox that that was supporting this type of calculations but because of migration to excel 2013 we noticed that tool is no longer working so I need to teach ppl how they can replace the toolbox formulas (most users have only basic knowledge of excel (like vlookup, sumif/s etc.). I do not want a formula that require helper columns

example.

table in A1:H15

Product Group	Org Unit	Item	P8	P9	P10	P11	P12
3PCS	3A7	3344120000	83	160	179	179	333
3PCS	3A7	3344299000	174	189	260	307	283
3PCS	3ANN	3344120000	4	17	20	20	46
3PCS	3ANN	3344299000	-7	-5	3	9	6
3PCS	3ANP	3344120000	-48	-22	-16	-16	35
3PCS	3ANP	3344299000	-83	-79	-61	-49	-55
3PCS	3EN	3344299000	-127	-117	-71	-41	-56
3PCS	3EW2	3344120000	11	134	165	165	411
3PCS	3EW2	3344299000	-163	-150	-89	-49	-69
3PCS	3EL	3344120000	58	93	102	102	172
3PCS	3EL	3344299000	74	79	103	118	110
3PCS	100045	3344120000	-416	-1057	-1216	-1216	-2496
3PCS	100045	3344299000	-465	-562	-1020	-1319	-1166
3PCS	3IAO	3344120000	-3	50	63	63	169
3PCS	3IAO	3344299000	107	117	164	194	179

<tbody>
</tbody>

I need to sum the data based on all three columns J:L and Period value in M1

table J1:M3

Product Group	Org Unit	Item	P10
3PCS	3A7	3344120000
3PCS	100045	3344120000

<tbody>
</tbody>

I came up with this formula =SUMPRODUCT(--($A$2:$A$25&$B$2:$B$25&$C$2:$C$25=$J2&$K2&$L2);INDEX($D$2:$H$25;;MATCH(M$1;$D$1:$H$1;0)))
that seems to work but I would like to know if it can be written in an easier and/or better way.

 

[Eric W]

This should also work for you:

=SUMIFS(INDEX($D:$H;;MATCH(M$1;$D$1:$H$1;0));A:A;J2;B:B;K2;C:C;L2)