How to Make the SUMIF Formula in Excel | Most Important Functions
🟢 LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel...
In this Excel video lesson, we'll learn how to use the SUMIF function in Excel. The SUMIF formula in Excel. In my experience, this Excel formula is widely used in job interviews and Excel tests for the job market.
The SUMIF function in Excel is one of the most important Excel functions. The SUMIF function in Excel helps us add all the values in a range if these values meet a specified criterion.
Unlike the SUM function, the SUMIF formula in Excel doesn't add all the values. The SUMIF formula only adds specific values. A practical example is as follows:
Let's say you have a sales spreadsheet in Excel and, in your report table, you have information such as date, customer name, product purchased, unit price, total price, and the name of the salesperson responsible for the sale.
Instead of adding up the entire total sold column and thus obtaining the Grand Total sold, you need to know the total sold by each salesperson.
So, instead of using the sum function, you can use the SUMIF function to help you solve this problem in Excel.
Then, the SUMIF function adds only the values that meet the criteria we specified.
#ExcelenteJoão #Excel #Dashboard