SumIFs for two tables

[Nissepiano]

Hi everyone!

I need some help.

I have two tables (short version, see below). And I want put these together with the and want to have the total sum (from table 1) for the categories in table 2. The R and Z is the positions in a grid. So I want to sum up the weights in table 1 for every category in table 2 in new table total weights per category. I hope someone can help me, I can do it a via several tables, but it is not so nice with so many tables.

Regards
Nisspeiano


Weights

R	393.333	420	446.667	473.333
Z
7.6	547	584	621	659
44.55	2116	2254	2401	2544
103.25	2116	2254	2401	2544
161.95	2116	2254	2401	2544
211.533	1458	1555	1651	1753
252	1458	1555	1651	1753
292.467	1458	1555	1651	1753

<colgroup><col span="4"><col></colgroup><tbody>
</tbody>

Categories

	393.333	420	446.667	473.333
7.6	LLW-2a	LLW-1	RISK	LOW RISK
44.55	LLW-2a	LLW-1	RISK	LOW RISK
103.25	LLW-2a	LLW-1	RISK	LOW RISK
161.95	LLW-2a	LLW-1	RISK	LOW RISK
211.533	LLW-2b	LLW-2a	LLW-1	LOW RISK
252	LLW-2b	LLW-2a	LLW-1	RISK
292.467	LLW-3	LLW-2a	LLW-1	RISK

<colgroup><col span="4"><col></colgroup><tbody>
</tbody>

 

[RasGhul]

Hi,

Is this what you needed?

Book1
	A	B	C	D	E
1	Weights
2	R	393.333	420	446.667	473.333
3	Z
4	7.6	547	584	621	659
5	44.55	2116	2254	2401	2544
6	103.25	2116	2254	2401	2544
7	161.95	2116	2254	2401	2544
8	211.533	1458	1555	1651	1753
9	252	1458	1555	1651	1753
10	292.467	1458	1555	1651	1753
11
12	Categories
13		393.333	420	446.667	473.333
14	7.6	LLW-2a	LLW-1	RISK	LOW RISK
15	44.55	LLW-2a	LLW-1	RISK	LOW RISK
16	103.25	LLW-2a	LLW-1	RISK	LOW RISK
17	161.95	LLW-2a	LLW-1	RISK	LOW RISK
18	211.533	LLW-2b	LLW-2a	LLW-1	LOW RISK
19	252	LLW-2b	LLW-2a	LLW-1	RISK
20	292.467	LLW-3	LLW-2a	LLW-1	RISK
21
22	Categories	Weights
23	LLW-1	12,299
24	LLW-2a	11,560
25	LLW-2b	2,916
26	LLW-3	1,458
27	LOW RISK	10,044
28	RISK	11,330
Sheet1

Cell Formulas
Range	Formula
B23	=SUMPRODUCT(($B$14:$E$20=A23)*$B$4:$E$10)