You have data with date format DD-MMM-YYYY like 24-Jun-2022. You need to create a report to sum the sales data per month.

Here is a sample data. The report is needed about sales volume per month.

We can use SUMIF function. We need three arguments:

1. Range: the column for dates, where the months are found.
2. Criteria: which month we are examining.
3. Sum range: where are the values to be calculated.

As months are abbreviated in column A, and the months are in the middle of string, we need to find the January asterisk Jan asterisk.

The sentence is here:

=SUMIF($A$3:$A$42;”*jan*”;$B$3:$B$42)

Another case is that month is a value in a cell not inside the function argument.

The Excel understands the second argument as * Jan *. Therefore we need to have asterisks in quotation marks. The dynamic cell reference needs to be separated with ampersands from the static asterisks.

=SUMIF($A$3:$A$42;”*” & E4 & “*”;$B$3:$B$42)