Tag: SUMPRODUCT

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.

 

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

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.

 

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

Using SUMPRODUCT to Count…

Read More