I am using this SUMPRODUCT formula =SUMPRODUCT(--($C$32:$C$1177=$C8),--($D$32:$D$1177=$D8),--($E$32:$E$1177))

and I'm getting the #VALUE! as a result.

Although when I copy a cut down version of the data into another file =SUMPRODUCT(--($C$22:$C$105=$C6),--($D22:$D105=$D6),--($E$22:$E$105))

this works perfectly. Could this be that the person I received the file from is using an older version of excel, and if that is the case what can I do?

Thanks.