You have a table of products, sales dates, and amounts:
Objective: Sum all sales amounts , from the same product, during a certain month and year.
Input in yellows cells only, any date within the month and year to be summed and a product code:
The answer has two formulas that are the same formula except one assumes the data is in a Table and one formula if the data is not in a Table:
Non – Table:
In addition I conditionally formatted the table to highlight the rows that fit the criteria with this formula:
Download workbook “Sum_within_month_and_year” from:
Downloads Written in Excel 2013