Excel TutorialTutorial

VLOOKUP Multiple Sheets Names Using the INDIRECT Function

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…

Read More
Excel TutorialTutorial

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…

Read More
Excel TutorialTutorial

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…

Read More