Sumifs based on multiple conditions

[g3org]

Hello everyone.
I do need a bit help with this formula:

=SUMIFS(Sheet1!A:J;'Freiburg (DBW5)'!C2;">="&'Freiburg (DBW5)'!A8;Sheet1!A:A;""<='Freiburg (DBW5)'!B8)
I want to sum column J from Sheet1 based on a cell from other sheet and between two date range. For any help i will be gratefull. Thank you.

Cortex_KM.xlsx
	A	B	C	D	E
1			2022
2	Din	Pana la	Freiburg (DBW5) - Amazon Logistics (PLZ 79108)	Geplante	Zulässige
3	03.01.22	09.01.22	KW1	#VALUE!
4	10.01.22	16.01.22	KW2	#VALUE!
5	17.01.22	23.01.22	KW3	#VALUE!
6	24.01.22	30.01.22	KW4	#VALUE!
7	31.01.22	06.02.22	KW5	#VALUE!
8	07.02.22	13.02.22	KW6	#VALUE!
9			KW7
10			KW8
11			KW9
12			KW10
13			KW11
14			KW12
15			KW13
16			KW14
17			KW15
Freiburg (DBW5)

Cell Formulas
Range	Formula
D3:D6	D3	=SUMIFS(Sheet1!B:J,'Freiburg (DBW5)'!C2,">="&'Freiburg (DBW5)'!A3,Sheet1!A:A,""<='Freiburg (DBW5)'!B3)
D7	D7	=SUMIFS(Sheet1!B:J,'Freiburg (DBW5)'!C2,">="&'Freiburg (DBW5)'!A7,Sheet1!A:A,""<='Freiburg (DBW5)'!B7)
D8	D8	=SUMIFS(Sheet1!A:J,'Freiburg (DBW5)'!C2,">="&'Freiburg (DBW5)'!A8,Sheet1!A:A,""<='Freiburg (DBW5)'!B8)

Named Ranges
Name	Refers To	Cells
Sheet1!_FilterDatabase	=Sheet1!$A$1:$P$149780	D3:D8

Sheet1 looks like this:

Datum	Station	DSP-Shortcode	Zustellmitarbeiter	Route	Servicetyp	Geplante Dauer	Anmelden	Abmelden	Geplante Gesamtentfernung
03.01.22​	Messkirch (DBW8) - Amazon Logistics (PLZ 88605)	ELAR			Rescue	6 Std.
03.01.22​	Messkirch (DBW8) - Amazon Logistics (PLZ 88605)	ELAR			Rescue	6 Std.
03.01.22​	Messkirch (DBW8) - Amazon Logistics (PLZ 88605)	ELAR	Alexandru Moraru	CA_A1	Standard Parcel	9 Std.	2022-01-03T09:16:14.922Z	2022-01-03T17:39:10.296Z	131​
03.01.22​	Messkirch (DBW8) - Amazon Logistics (PLZ 88605)	ELAR	Alexandru Mitulescu	CA_A2	Standard Parcel	9 Std.	2022-01-03T09:11:34.849Z	2022-01-03T17:38:09.226Z	127​

 

[Legacy 143009]

=SUMIFS(Sheet1!A:J;'Freiburg (DBW5)'!C2;">="&'Freiburg (DBW5)'!A8;Sheet1!A:A;""<='Freiburg (DBW5)'!B8)

You are quite close:

=IF('Freiburg (DBW5)'!C2>='Freiburg (DBW5)'!A8;SUMIFS(Sheet1!J:J;Sheet1!A:A;"<="&'Freiburg (DBW5)'!B8))

 

[Fluff]

How about

=SUMIFS(Sheet1!J:J,Sheet1!A:A,C$2,Sheet1!A:A,">="&A3,Sheet1!A:A,"<="&B3)

 

[Fluff]

You are quite close:

You sure about that.

 

[Legacy 143009]

You sure about that.

I've edited after seeing your answer. I am not sure about the desired outcome but this (my edited formula) should be the correct notation.

 

[g3org]

Thanks to you guys, my project is working. Many thanks

 

[Fluff]

Glad we could help & thanks for the feedback.