5 Groovy SUMPRODUCT Function Examples

This video tutorial explains 5 groovy SUMPRODUCT function examples. Read the full tutorial here - https://www.computergaga.com/blog/5-g...

SUMPRODUCT is one of the great Excel functions. It can turn you from an Intermediate/Advanced user to an Excel guru instantly.

Learn ALL the best Excel functions - https://amzn.to/3Rg87Go

Are you a SUMPRODUCT function newbie?
Check out this guide to the SUMPRODUCT function - https://bit.ly/3jEA2Aj

These 5 special SUMPRODUCT examples will show what this function is capable of.

Check out the timings of each tip so you can skip to the one you need (if you can't watch them all in one go).

00:00 – Count and sum the values for a specific month of a list.
06:38 – Count all occurrences of a word(s) within a range.
10:54 – Count the unique values.
14:18 – Sum the top 3 values of a list.
17:22 – Create a two way lookup using SUMPRODUCT

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!
LinkedIn ► LinkedIn: 18737946
Instagram ► Instagram: computergaga1
Twitter ► Twitter: computergaga1

• #howto_style
• #sumproduct_function
• #sumproduct_formula
• #microsoft_excel
• #excel_formulas
• #advanced_excel
• #advanced_excel_tips
• #advanced_excel_formulas
• #computergaga
• #alan_murray
• #sumproduct_formula_examples
• #sum_top_3
• #count_unique_values
• #count_values_for_specific_month
• #excel_sumproduct
• #excel_sumproduct_function_tutorial
• #excel_sumproduct_formula
• #excel_sumproduct_text
• #excel_functions
• #sumproduct_in_excel_example
• #excel_sumproduct_examples
• #sum_and_product
• #sumproduct_with_criteria