=((SUMPRODUCT(--('Group Rate'!$A$3:$A$255=M2),--('Group Rate'!$B$3:$B
$255=F2),--('Group Rate'!$E$3:$E$255))))

I get a Value error when trying to use the above formula but am unsure
why as it does work for similar instances. Any help is appreciated.