We have used a helper column to find the month from the date and is formatted as name of the month by using TEXT function. The criteria month is them matched with this column and the number againt it is added to get the final answer.
Checking if a date is maximum for all dates for the same month
Calculate number of months between two dates
Counting an item for same dates but for last month
Category: Math and trigonometry
Adds the cells specified by a given criteria
SUMIF(range, criteria, [sum_range])
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM