SUMPRODUCT showing #VALUE - Can't understand why it won't work

Ok so I have two unhidden tabs on the attached spreadsheet.....

Hopefully the results I want to see are quite self-explanatory. I want the formula in the second tab, to look at the cost information in the first tab and show me cost total for anything coded to "OR" and "GBNHA271693".

I've used this formula, for this kind of task before but it's not playing ball today. Anybody any ideas?

Here's the formula

=SUMPRODUCT((Step2!C2:C795='Andy Hull'!B6)*(Step2!O2:O795='Andy Hull'!B4:F4),(Step2!G2:G795))

It's this part causing the issue.
Step2!O2:O795='Andy Hull'!B4:F4

Comparing values in O to a multicell range B4:F4
Can't do that.
That should just be B4
And it should be using some absolute references.

Try
=SUMPRODUCT((Step2!C$2:C$795='Andy Hull'!B6)*(Step2!O$2:O$795='Andy Hull'!B$4),(Step2!G$2:G$795))

Try

=SUMPRODUCT((Step2!$C$2:$C$795='Andy Hull'!$B6)*(Step2!$O$2:$O$795='Andy Hull'!$B$4)*(Step2!$G$2:$G$795))

Your "OR" in "Andy Hull" has a leading blank (" OR") so remove