SUMPRODUCT with named dynamic ranges

Hello,

I'm stuck and need some help . I'm trying to count how many values there is in the
table with the all 4 different criteria's. All values are text not including A:A column this one is the date.
The function below works in these ranges (H24:H111).... But if ill put named dynamic range its returns to #VALUE!

Please Login or Register  to view this content.

That's the named ranges:
Date (range)

Please Login or Register  to view this content.

Summary (range)

Please Login or Register  to view this content.

Category (range)

Please Login or Register  to view this content.

Location (range)

Please Login or Register  to view this content.

If ill use them separately it works fine

Please Login or Register  to view this content.

but not combined together

Please Login or Register  to view this content.

Am I missing something? :/

Thanks

Dynamic formula for Summary should be

Please Login or Register  to view this content.

Similarly Change for Date, Category and Location.
Formula in E 3in Sheet1, then drag down.

Please Login or Register  to view this content.