Another way (without the need of CSE):
=IFERROR(SUMPRODUCT((Sheet1!$A$5:$A$9='Results Sheet'!$H$1)*(Sheet1!$B$5:$B$9='Results Sheet'!$H3)*Sheet1!$C$5:$C$9),"")
Place in 'Results Sheet'!I3
Another way (without the need of CSE):
=IFERROR(SUMPRODUCT((Sheet1!$A$5:$A$9='Results Sheet'!$H$1)*(Sheet1!$B$5:$B$9='Results Sheet'!$H3)*Sheet1!$C$5:$C$9),"")
Place in 'Results Sheet'!I3
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks