Скачать или смотреть Sum the Top 5 Values - Excel Formula

In this video, we sum the top 5 values in a range using an Excel formula. This formula can easily be adjusted to sum the top 3, top 10 or whatever you need.

Think you need to improve your Excel formula skills?

In the video, the SUMPRODUCT and LARGE functions are used together to achieve our goal.

An array constant is used to return the top 5 values with the LARGE function. This element is what you need to change to return something different such as the top 3.

See what else SUMPRODUCT can do with the video showing 5 awesome examples -    • 5 Groovy SUMPRODUCT Function Examples  

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 ►   / 18737946  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1