???? LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... ???? FREE DOWNLOADABLE SPREADSHEET: https://excelentejoao.com.br/wp-conte... In this free Excel video lesson, we will learn how to Sum by Week in Excel using the SUMIFS function with Multiple Criteria in Excel step by step from scratch with a practical example. The sum function in Excel adds all selected values. The sumifs formula in Excel adds all values ​​that meet a criterion. The sumifs function in Excel adds the values ​​from a criterion but here we can use multiple sum criteria. In this Excel video lesson, we will learn how to use the sumif function in the Excel spreadsheet, sumif formula, add Excel dates, Excel due date, Excel due date alert, sales spreadsheet, inventory control spreadsheet, how to do the sumif function in Excel in practice step by step with practical examples, free Excel tutorial, how to add in Excel only some values ​​that meet a criterion, how to add in Excel only what is equal to a condition, sumif formula with 1 criterion, sumif with more than one criterion, sumif with multiple criteria in Excel, Excel tutorial to save time in your daily life. In this Excel video lesson, we will learn how to use the sumif function in Excel to add dates. Sumif formula with dates, sumif by date, add with criteria, add with condition, add according to date, sumif formula in Excel. The sumif formula in Excel helps us to add not everything but only what meets a criterion. In this way, we can perform analyses in Excel using one of the most important functions of all, which is the sumif function in Excel. In this practical example, with a real example, to help us in our daily lives and in the job market, as well as to automate tasks in Excel and automate processes. Let's learn how to add by date. I have a sales spreadsheet with several pieces of information, such as the date of sale and order, product, customer name, quantity purchased, total purchased, purchase region and shipping. Let's say I want to know the total sold by date. I can use the sumif function to help me with this analysis in Excel, because I don't want to add everything, but only what meets a criterion. In this case, the date could also be month, day, year and week, and so on. You can use whatever criteria you want. In this Excel video lesson, we will learn how to add by month in the Excel spreadsheet, for example. Let's learn how to add by month and also use another criterion, such as product or customer. so that we can use the sum formula in Excel or the sum function in Excel to sum carefully and add only what we need, we can use the sumif function in Excel or the sumifs function. The SUMIF function adds the values ​​in a range that meet a criterion that you specify. In this practical Excel example, we will add by months, that is, how much was sold in each month, how much was sold in the month of January, February, March, April, and so on. But in addition to that, we also need to add another criterion to the sumif formula, the ifs formula, in Excel, such as the name of the product or the name of the customer. so that we can add by months, we first need to have the months extracted from the dates, that is, we will need to extract only the month from a complete date, and for that we can use the text function or the text formula in the Excel spreadsheet. The text formula allows us to extract only the day or only the month or only the year from a complete date, and in this way we can have the criterion that we need to use in the sumif function, which is the month criterion. #ExcellentJoão #Excel #Dashboard