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.
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