???? LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... In this free Excel video lesson, we will learn how to Sum by Week in Excel using the SUMS function with Various Criteria in Excel step by step from scratch with practical example. The sum function in Excel adds up all selected values. The sumase formula in Excel adds up all the values ​​that meet a criterion. The sumase function in Excel adds the values ​​based on one criterion but here we can use several sum criteria. HOW TO ADD BY MONTH IN EXCEL: • How to Add by Month in Excel with more... In this Excel video lesson, we will learn how to use the sums function in the Excel spreadsheet, formula sums, add Excel dates, excel due date, due date alert Excel, sales spreadsheet, inventory control spreadsheet, how to do the sumase 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 criteria, how to add in Excel only what is equal to a condition, formula adds up with 1 criterion, adds up with more than one criterion, adds up with several criteria in Excel, Excel tutorial to save time in everyday life. In this Excel video lesson, we will learn how to use the sum function in Excel to add dates. Formula Sum if with dates, sum if by date, add with criteria, add with condition, add according to date, formula sum in Excel. The sumase formula in Excel helps us to add up not everything but only what meets a criterion, this way we can carry out the analysis in Excel through one of the most important functions of all, which is the sumase function in Excel. in this practical example with a real example to help us in our daily lives and in the job market and also to automate tasks in Excel and automate processes Let's learn how to add by date I have a sales spreadsheet with various information such as date of sale ed of the order product the name of the customer quantity purchased Total purchased region of purchase and shipping Let's say I want to know the total sold by date I can use the sum if function to help me with this analysis in Excel because I don't want to add everything up but just what meets a criteria 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 up by month in the Excel spreadsheet, for example. We will learn how to add up by month and even 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 add carefully and add only what we need, we can use the sumase function in Excel or the sumase function. The SUMIF function sums the values ​​in a range that meet a criterion that you specify. In this practical Excel example, we will add up by months, that is, how much we sold in each month, how much we sold in the month of January, February, March, April and so on. But in addition to this we also need to add another criterion to the somase formula, the ifs formula, in Excel, such as the product name or customer name. so that we can add 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 this we can use the text function or even the text formula in the Excel spreadsheet, the text formula in allows you to extract from a complete date just the day or just the month or just the year and this way we can have the criteria we need to use in the sum function, which is the month criterion. #ExcelenteJoão #Excel #Dashboard