26,881 views
🟢 LEARN EXCEL WITH ME AND BECOME A REFERENCE IN THE JOB MARKET: http://excelentejoao.com.br/sejaexcel... #Excelentejoao #Excel #Dashboard In this Excel video lesson, we will learn how to add up by month in Excel using the sumif function in Excel to help us solve this problem. The sumif function in the Excel spreadsheet can help you automate repetitive tasks and automate processes that you do daily in your day-to-day life and in your company. The sum function in Excel helps us add values. We can select values individually, cell by cell, one at a time, or we can select a large range of cells in Excel to add up the values that are contained in the cells we selected. The sumif function in Excel allows us, instead of adding up all the selected values in the spreadsheet, to add up only the values that correspond to the criterion we want to be met. In other words, every time a criterion is met, every time a criterion is true, the sumif function returns the sum value of that specific range. And in turn, the sumif function in Excel is very similar to the sumif function, however, in the sumif function we can use only one criterion condition. In the sumif function, we can use several different criteria and conditions to perform a segmented sum in Excel. Thus, adding only the values that we need and that are within the specified criterion.