1Answers

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

Asked by: Pamela Clarke 210 views IT

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

Welcome Guest.

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

Asked by: Pamela Clarke 210 views IT

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

+7

VotesThis 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 |