SUMPRODUCT Function in Excel |

Published: 05 February 2022
on channel: 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


Watch video SUMPRODUCT Function in Excel | online, duration hours minute second in high quality that is uploaded to the channel My Digital Quill 05 February 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 309 times and liked it 12 visitors.