Скачать или смотреть SUMPRODUCT Function Multiple Criteria

This video illustrates how to use the SUMPRODUCT Function with "multiple criteria" or "conditions" in Excel. In this example we have a list of two different loan types at multiple branch locations. The objective is to calculate the "Weighted Average Interest Rate" based on two criteria or conditions - one single loan type and one single branch. This video displays how to insert conditional arguments within the SUMPRODUCT Function to return a Weighted Average based on criteria.

Learn more about Excel Functions & Features with this book at Amazon:
https://amzn.to/3xtLmXp
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via this link.

If you want to follow along with this video you can click the link below to download this workbook at The Excel Cave Website.

https://theexcelcave.weebly.com/sumpr...