Your right Harlan,

The formula should use '=' and separate the search criteria:
=SUMPRODUCT((A1:A3=D1)*(B1:B3=E1)*(C1:C3=F1))
However, I can't see why 1+ would be needed.

Ola