Jeff, thanks for the formula however it doesnt seem to be workingi keep getting #value! when i use this formula

=SUMPRODUCT(($A3='Master (2)'!$C$3:$C$280)*(B$2='Master (2)'!$B$3:$B$280)*('Master (2)'!$D$3:$V$280))