How to use a function to find the corresponding result by two or more conditions

1 Answers

1. +7Votes  

   This can be done:

   M5:

   =SUMPRODUCT(($B$2:$B$100=J5)*($C$2:$C$100=K5)*( $D$2:$D$100))

   Pull down and copy.

   Carter- August 8, 2019 |