Here is our scenario. We have at database of purchases to which we need to apply a discount. The discount applied depends on the product category: A, B or C and the quantity purchased. The lookup tables for each category are on separate sheets as shown below. We are going to achieve this using a…Read More
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… [contentblock id=2…Read More
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…Read More