I'm been trying to use sumifs function but something is not working and I don't know what it is

I'm trying to use a sumifs function that would search for two criterias on a different sheet (one is text and within a column and the other is a date within a row) within a range huge range of dat...