SUMIF on two tables

[Deverti]

im confused as to how i should create a formula to get me a sum of a dynamic range based on a value present in both my tables

i ve been trying to reference the relevant table columns as range and criteria but im screwing something up.
specifically for the example i need the sums of "Rent Soll" or "Rent Ist" from the upper table to be displayed in the lower table if "Name 'x'" in column A from both tables match

really appreciate any help

Generating an output with XL2BB only ever crashes my excel for some reason ~
Link to temporary example upload: /tmp/files - Temporary File Hosting

 

[Fluff]

How about

example.xlsx
	A	B	C	D
1	Eigentümer	Bezeichnung	Rent Soll	Rent Ist
2	Name A	A_Prop 1	1351792	1351792
3	Name A	A_Prop 1
4	Name A	A_Prop 2	784536	782540
5	Name B	B_Prop 1	531904	279283
6	Name B	B_Prop 1
7	Name B	B_Prop 2	625482	596412
8	Name B	B_Prop 3	1562347	1562347
9	Name C	C_Prop 1	1859625	1859625
10	Name C	C_Prop 2	1084000	1084000
11	Name C	C_Prop 3	528527	526951
12
13
14
15
16
17
18	Inhaber	-	Total Rent Soll	Total Rent Ist
19	Name C		3472152	3470576
20	Name B		2719733	2438042
21	Name A		2136328	2134332
22	#N/A		0	0
23	#N/A		0	0
24	#N/A		0	0
25	#N/A		0	0
26	#N/A		0	0
27	#N/A		0	0
28	#N/A		0	0
29	#N/A		0	0
30	Ergebnis			11
test2

Cell Formulas
Range	Formula
A19:A29	A19	=LOOKUP(2,1/(COUNTIF($A$18:A18,Tab_Hypotheken[Eigentümer])=0),Tab_Hypotheken[Eigentümer])
C19:C29	C19	=SUMIFS(Tab_Hypotheken[Rent Soll],Tab_Hypotheken[Eigentümer],[@Inhaber])
D19:D29	D19	=SUMIFS(Tab_Hypotheken[Rent Ist],Tab_Hypotheken[Eigentümer],[@Inhaber])
D30	D30	=SUBTOTAL(103,[Total Rent Ist])
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Deverti]

mh i wish
=SUMIFS(Tab_Hypotheken[Rent Soll],Tab_Hypotheken[Eigentümer],[@Inhaber])
gives me "0" as results

edit:
was using SUMIF instead of SUMIFS, duh

perfect, thank you :v

 

[Fluff]

Is that in your test workbook?
Also do you have a line feed between Rent & Soll

 

[Deverti]

that was meant to tackle my pre edit response i suppose

thanks for the support tho^^

 

[Fluff]

It was indeed.
Glad to help & thanks for the feedback.