Sumif problem

[mad4max]

Hello,
First of all I wish you all an Happy New Year!
I have a problem where I can't find solution as I don't understand why it doesn't work! I get zero as result and it's impossible!
I should get a total of attendees by groups of people.
There are 7 groups coming around the month...
I need to have a total by attendee, a total by day and a total by group.
I used the =sumif formula for the total by groupe, but... doesn't work and I don't get what is wrong and why I get the result 0 instead of the summed items...
Here some snapshot of the file. I saw that I can't add the file itself so hope it's ok like that:

Thank you for your always valuable help!
Best regards.

 

[Fluff]

With all the xIFS functions the ranges must be the same size, try

=SUMPRODUCT(($A$7:$A$43=A48)*($F$7:$AJ$43))

 

[Special-K99]

It's only adding the first column, ie F
Use
=SUMPRODUCT(($A$7:$A$43=A48)*($F$7:$AJ$43))