10,112 views
🟢 LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... In this Excel video lesson, we will see about the SOMARPRODUTO Function in Excel with several practical and real everyday examples and the job market and we will also learn the difference between the SOMASE Excel formula and the sumarproduto formula in the Excel spreadsheet. As the name suggests, the sumproduct function adds the multiplications made in the Excel table matrix. Let's see how to use the SUMPRODUCT function to add products with several different conditions, several criteria, with different practical examples, etc. We can say that the SUMPRODUCT function in Excel is an improvement on the SUMPRODUCT function in Excel, because we can add products with various conditions and there is missing information. We can use SUMPRODUCT to sum the product of corresponding values in one or more matrices in the Excel spreadsheet. #ExcelenteJoão #Excel #Dashboard