<tbody>
2019
2019
2019
Result Flag
Result
1234
54
51
77
5678
14
#N/A
101
#N/A
=SUMPRODUCT(Sheet2!$B$3:$D$4*(Sheet2!$B$1:$D$1=B$1)*(Sheet2!$B$2:$D$2="Result")*(Sheet2!$A$3:$A$4=$A3))
</tbody>
I'm using the above SUMPRODUCT formula on a large dataset. In testing we...