My Digital Quill | Excel Formulas and Functions #26 | SUMPRODUCT Function in Excel | Excel tips and tricks | Excel #shorts
SUMPRODUCT Function is math function in Excel that multiply the corresponding components of a given array and then return the sum of the products. It can be used to calculate a weighted average.
This example explains on how to use SUMPRODUCT function for a simple problem whereby range of unit price and quantity of units sold is given. Typically the norm is to obtain a grand total by multiplying the product price with the units sold for each product and then to add all the revenues to get a grand total. However, with the help of this function we can just define the two arrays and the answer would come the same.
Credits:
Thumbnail Photo by Justin Morgan on Unsplash
LearnYouandMe
• Sumproduct function in Excel with exa...
Please check out more Excel tips and tricks from the playlist link down below:
• Excel Tips and Tricks
Check this playlist for Excel formulas and functions:
• Excel Formulas and Functions Series
Free Excel Course available on formatting techniques in here:
• Excel Formatting Techniques
🔔 Subscribe for free Office Tutorials at My Digital Quill:
/ @mydigitalquill8945
#sumproductfunction #sumproductfunctioninexcel #excelmathfunctions #Excelformulasandfunctions #Exceltipsand tricks #Excelshorts
#MyDigitalQuill
Смотрите видео SUMPRODUCT Function in Excel | онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал My Digital Quill 05 Февраль 2022. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 309 раз и оно понравилось 12 посетителям.