## Excel’s SUMPRODUCT with Multiple Criteria Including AND and OR Criteria

In a previous tutorial we explained how to use SUMPRODUCT to count or sum values based on a single criteria.  In this tutorial we want to explore how to include multiple criteria in your SUMPRODUCT formula – multiple criteria using AND or OR logic. Here is our scenario featuring a database of accounts… Counting with… Read More »Excel’s SUMPRODUCT with Multiple Criteria Including AND and OR Criteria

## Using Excel’s SUMPRODUCT with IF Criteria/Conditions

SUMPRODUCT with Criteria This tutorial assumes you understand the basic functionality of SUMPRODUCT – in that it finds the product of corresponding values in each column/row/array and then sums those calculation results. We will focus on the opportunities to count and sum records based on criteria using SUMPRODUCT. Using SUMPRODUCT to Count with Criteria In… Read More »Using Excel’s SUMPRODUCT with IF Criteria/Conditions

## Perform Weighted Average Calculations Using Excel’s SUMPRODUCT Function

Weighted Average Calculations A normal average calculation sums values and then divides by the number of values.  This basic average calculation works fine unless you need to give a different weight to each value.  For example, our students take 5 exams a year and we need to calculate their overall percentage at the end of… Read More »Perform Weighted Average Calculations Using Excel’s SUMPRODUCT Function