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))
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))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks