How to Use Sumproduct to Divide instead of Multiply
Sumproduct is powerful Excel formula to multiply 2 or more paired ranges (aka arrays or lists) together and sum the product. This is most commonly used in areas like payroll where you have a list of people, their hours worked, and their pay rate. If you wanted to get the total payroll for the period you have … Continue reading “How to Use Sumproduct to Divide instead of Multiply”