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
[TABLE="width: 368"]
<colgroup><col span="4"><col></colgroup><tbody>[TR]
[TD]R[/TD]
[TD]393.333[/TD]
[TD]420[/TD]
[TD]446.667[/TD]
[TD]473.333[/TD]
[/TR]
[TR]
[TD]Z[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7.6[/TD]
[TD]547[/TD]
[TD]584[/TD]
[TD]621[/TD]
[TD]659[/TD]
[/TR]
[TR]
[TD]44.55[/TD]
[TD]2116[/TD]
[TD]2254[/TD]
[TD]2401[/TD]
[TD]2544[/TD]
[/TR]
[TR]
[TD]103.25[/TD]
[TD]2116[/TD]
[TD]2254[/TD]
[TD]2401[/TD]
[TD]2544[/TD]
[/TR]
[TR]
[TD]161.95[/TD]
[TD]2116[/TD]
[TD]2254[/TD]
[TD]2401[/TD]
[TD]2544[/TD]
[/TR]
[TR]
[TD]211.533[/TD]
[TD]1458[/TD]
[TD]1555[/TD]
[TD]1651[/TD]
[TD]1753[/TD]
[/TR]
[TR]
[TD]252[/TD]
[TD]1458[/TD]
[TD]1555[/TD]
[TD]1651[/TD]
[TD]1753[/TD]
[/TR]
[TR]
[TD]292.467[/TD]
[TD]1458[/TD]
[TD]1555[/TD]
[TD]1651[/TD]
[TD]1753[/TD]
[/TR]
</tbody>[/TABLE]


Categories
[TABLE="width: 368"]
<colgroup><col span="4"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]393.333[/TD]
[TD]420[/TD]
[TD]446.667[/TD]
[TD]473.333[/TD]
[/TR]
[TR]
[TD]7.6[/TD]
[TD]LLW-2a[/TD]
[TD]LLW-1[/TD]
[TD]RISK[/TD]
[TD]LOW RISK[/TD]
[/TR]
[TR]
[TD]44.55[/TD]
[TD]LLW-2a[/TD]
[TD]LLW-1[/TD]
[TD]RISK[/TD]
[TD]LOW RISK[/TD]
[/TR]
[TR]
[TD]103.25[/TD]
[TD]LLW-2a[/TD]
[TD]LLW-1[/TD]
[TD]RISK[/TD]
[TD]LOW RISK[/TD]
[/TR]
[TR]
[TD]161.95[/TD]
[TD]LLW-2a[/TD]
[TD]LLW-1[/TD]
[TD]RISK[/TD]
[TD]LOW RISK[/TD]
[/TR]
[TR]
[TD]211.533[/TD]
[TD]LLW-2b[/TD]
[TD]LLW-2a[/TD]
[TD]LLW-1[/TD]
[TD]LOW RISK[/TD]
[/TR]
[TR]
[TD]252[/TD]
[TD]LLW-2b[/TD]
[TD]LLW-2a[/TD]
[TD]LLW-1[/TD]
[TD]RISK[/TD]
[/TR]
[TR]
[TD]292.467[/TD]
[TD]LLW-3[/TD]
[TD]LLW-2a[/TD]
[TD]LLW-1[/TD]
[TD]RISK
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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)