COUNTIFS criteria over multiple columns - #VALUE error

Hi,

I have a data sheet with multiple columns and generally need to COUNT how many records match the following criterias:

1) Equal or older than 1st day of current month in current year
2) Below first day of next month in current year
3) content in columns D:E matches a specific string

Steps 1 and 2 are not problem, but once I add the third criteria the formula breaks, likely because the criteria is part of a `COUNTIFS` statement which does not allow to match a single string across multiple columns. It works just fine when I change the column range from `D:E` to `D:D`.

How can I achieve the above with a single formula?

Current formula:
`=COUNTIFS(Data!$A:$A,">="&DATE(YEAR($F$1),C$3,1),Data!$B:$B,"<"&DATE(YEAR($F$1),MONTH(C$3)+1,1),Data!$C:$G,$A4)`

Please see sample for more details.

Thank you!

Excel Sample.xlsx

Summary

C4=SUMPRODUCT((Data!$A$2:$A$6>=DATE(YEAR(Summary!$F$1),MONTH(Summary!C$3),1))*(Data!$B$2:$B$6<EDATE(DATE(YEAR(Summary!$F$1),MONTH(Summary!C$3),1),1))*(Data!$C$2:$G$6=Summary!$A4))

=SUMPRODUCT(--(Data!$A$2:$A$10>=DATE(YEAR($F$1),MONTH(C$3),1))*(Data!$B$2:$B$10<DATE(YEAR($F$1),MONTH(C$3)+1,1))*(Data!$C$2:$G$10=$A4))


This is correct for me