Greetings, all

I'm attempting to sum a column of VALUES if/when the criteria in two other
columns of TEXT is met. However, the SUMPRODUCT function I'm using is not
returning anything (no errors, but no sum either).

=SUMPRODUCT(--($C$2:$C$4000="New York"),--($A$2:$A$4000="HOUSE"),$X$2:$X$4000)

Any ideas why this particular formula isn't working, or suggestions for
other means of capturing what I need?

Thanks in advance