Todo o Poder da Função SOMARPRODUTO no Excel

CLICK HERE TO LEARN MORE ABOUT THE COMPLETE IMPRESSIVE EXCEL COURSE: https://lp.hashtagtreinamentos.com/es... -------------------------------------------------------------------- DOWNLOAD THE HANDBOOK WITH THE 10 MOST IMPORTANT EXCEL FORMULAS: https://excelparaestagio.klickpages.c... To receive free daily content on Microsoft Excel, VBA, and Power BI, join our Telegram group: https://t.me/joinchat/AAAAAFVJr0C7Il-... In our videos, we teach various Excel tips and tricks. May you develop using this tool! ----------------------------------------------------------------------- ► Spreadsheet used in the video: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/s... ----------------------------------------------------------------------- Hashtag Treinamentos ► Subscribe to our channel: https://bit.ly/2O6A4RP ► Turn on notifications (click the bell)! ► Like our video! ----------------------------------------------------------------------- Social Media ► Blog: https://bit.ly/2MRUZs0 ► YouTube: https://bit.ly/2O6A4RP ► Instagram: https://bit.ly/2F7B6t4 ► Facebook: https://bit.ly/2UA4SwY ► Telegram: https://t.me/joinchat/AAAAAFVJr0C7Il-... ► TikTok: https://bit.ly/3dUpwkW ----------------------------------------------------------------------- TOP Videos: ► The 5 BASIC Excel FORMULAS you MUST LEARN before VLOOKUP    • As 5 FÓRMULAS BÁSICAS do Excel que você TE...   ► VLOOKUP - Complete Step-by-Step (without (complication)    • PROCV - Passo a Passo Completo (sem compli...   ► Pivot Table - How to create an Excel Pivot Table in 5 steps!    • Tabela Dinâmica - Como fazer Tabela Dinâmi...   ► EXCEL SPREADSHEET to IMPRESS ANYONE    • PLANILHA EXCEL para IMPRESSIONAR QUALQUER UM   ► Learn EVERYTHING about creating CHARTS in EXCEL    • Aprenda TUDO sobre como criar GRÁFICOS no ...   ----------------------------------------------------------------------- In this video, I'll show you the full power of the SUMPRODUCT function in Excel! Many people (including myself until recently) don't understand the full potential of the SUMPRODUCT formula in Excel. Initially, as many people believe, the Excel SUMPRODUCT function is used when you need to add the product of two matrices. How so? This function can make things easier when you need to multiply two things (prices and quantities, for example) and then add them all together. What many people don't know is that this is just one of the many applications of the incredible SUMPRODUCT function. In this video, I'll show you five examples of this function so you can understand its many different applications. The most useful application, in my opinion, is when you use the Excel conditional SUMPRODUCT. That's right, in addition to performing the sum of products (adding all the multiplications), you can choose which cells to consider in this sum and multiplication, basically like an Excel SUMPRODUCTIF. It's easy to understand because what we're doing is an Excel sum of products "if" the cells meet a certain condition. Another application of the Excel conditional SUMPRODUCT is to do exactly what we get with the COUNTIF and SUMIF formulas, but it doesn't stop there. With this function, we can do things that not even the COUNTIF and SUMIF formulas can do! ----------------------------------------------------------------------- #excel #vba #hashtagtraining