SUMPRODUCT Function in Excel |

Опубликовано: 05 Февраль 2022
на канале: My Digital Quill
309
12

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 посетителям.