The Awesome SUMPRODUCT Function - Guide and 5 Great Examples | Alan Murray | Skillshare

# The Awesome SUMPRODUCT Function - Guide and 5 Great Examples

#### Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
7 Lessons (31m)
• 1. Introduction

1:56
• 2. The Definitive Guide to the SUMPRODUCT Function

8:00
• 3. Example 1 - Count and Sum the Sales from a Specific Month

6:22
• 4. Example 2 - Count the Occurrences of a Specific Word in a Range

4:18
• 5. Example 3 - Count the Unique Values ONLY in a Range

3:25
• 6. Example 4 - Sum the Top 3 Values

3:05
• 7. Example 5 - Two Way Lookup Formula with SUMPRODUCT

4:18

In this class we explain the amazing SUMPRODUCT function of Excel inside-out. And then demonstrate 5 'real world' practical examples of its use.

This function is incredibly useful and is a kind of formula utility knife. It can help us tremendously when analysing data.

The 5 examples in the class will nicely showcase the benefits of learning SUMPRODUCT.

We will see SUMPRODUCT sum and count values based on multiple conditions, use it for a two way lookup and much more.

As always the exact files that I use in the lessons are available to download from the project section to follow along and practise. There is also a project to complete to test what you have learnt.

Ok, lets get going. Enrol and I'll see you inside.