SumProduct and Linking to Another Sheet

[Dan]

Hello,

I'm trying to link to another sheet while using SUMPRODUCT but I always
get a #VALUE! error. It works fine if the data is on the same page.
It's only when I link to it from another page.

This is my formula:
=SUMPRODUCT(--(H20:L28="TV"),--(DAR!E9:E18="Y"))

Is there a way to do this without pulling the data that I'm using onto
the same sheet?

Any help is much appreciated!