unable to fix issue with "sumifs" and 4 criterias

Hello,
I am trying to use the "sumifs" (in german: summewenns" to get results out of 4 criteria which all must be true.
I am enclosing my file...

Issue:
In TAB "Matchday", I have search criterias in cells B2-E2
The database is in TAB "Database"

I cell B106, I am using the "sumifs" formular. However, that formular is already shoing a 0 after the second criteria is involved
The summaries I like to get is found in DATABASE column H

When doing the manual filtering, I should see in cell B106 the summary of 4

I do not know what I am doing wrong...
Can you help please?
Thank you very much
Thomas

How about

Formula:

Please Login or Register  to view this content.

Thank you very much Fluff13

You're welcome & thanks for the feedback

Hello Fluff13, may I contact you again.
I was trying to transform your solution to my original file. It did not work. Even if I add ...."="&.... to each criteria, the result is always "0" and not "4"
Can you think of any solution or got an idea what the problem can be?
The file is very big (60MB)... So, its not possible to send it here
Thank you

Formula is OK.
Your data might have issue. Maybe criteria doesn't match Database.
Maybe formatting is problem (for example, if I enter 1-1 I will get date 1.1.2023 and not text value 1-1).

Without being able to see the file, it's very difficult to tell what the problem could be.

Thanks for the quick reply. I will check now carefully all formatings...

Fluff13... I sent you a PM... did you receive? I do not see it in my sent folder

You need to put the link in the thread so that anyone can access it. Everything needs to stay on the board.

ok...got it...
This is the link in Dropbox. The file is called : S2019-today.xlsm

dropbox.com/scl/fi/lxqcmj9z0xptqjbajkuwn/S2019-today.xlsm?rlkey=nai7vx5fed0eyh6oq5xen0pfw&dl=0[/url]

However, the file is about 55MB. Hope this will work to download. If not, please tell what I need to do.
Sorry for any inconvinience.

The Database is in TAB "S2019-today"
The "sumifs" formular is to be used in TAB "Matchday"
The column "B" in TAB Matchday is holding the sumifs formular already.

For your reference: Cell B182 should show the result: 4

Thank you
Thomas

The ELOh column has numbers like 1638 whilst the ELOh-Gr column has text values like 1700-1799 which is why you get 0

Î formated everything to "text" and also tried "numbers". No change of results. The column B in TAB Matchday remains as "0"

The values in ELOh must be an exact match with the values in col ELOh-Gr

Yes Fluff13, that was the reason. Thanks for all your help

Glad to help & thanks for the feedback.