How to Sum per Month in Excel and add more criteria like Product, Customer etc | Sumifs function

In this Excel video tutorial, let's learn how to Sum per month in an Excel spreadsheet for example. Let's learn how to sum per month and even use one more criterion such as product or customer. How to sum if the condition is met in Excel.

so that we can use the sum formula in Excel or the sum function in Excel to add judiciously and add only what we need, we can use the sum formula in Excel or the sum function with a criteria.

The SUMIF function sums the values in a range that meet a criteria you specify.

In this practical example of Excel, let's add up by months, that is, how much was sold in each of the months, how much was sold in the month of January, February, March, April, and so on. Excel as for example the name of the product or the name of the customer.

so that we can sum per 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 even the text function in Excel spreadsheet.

the text formula allows us to extract from a complete date just the day or just the month or just the year and in this way we manage to have the criteria we need to use in the sum if function which is the criterion of the month.

#JopaExcel #Dashboard #Excel