In CoL C I have:
804
805
806
..
...


In Cell H1 I have the following which works fine:

=SUMPRODUCT((DUMP!$C$3:$C$381="804")*(DUMP!$F$3:$F$381=Sheet4!C$2)*(DUMP!$G$3:$G$381="Won"))

However I would like this to become:

=SUMPRODUCT((DUMP!$C$3:$C$381=Z1)*(DUMP!$F$3:$F$381=Sheet4!C$2)*(DUMP!$G$3:$G$381="Won"))

where Z1 contains the value 804

WHIch doesnt quite work, is this a formatting issue?