SUMIF(...)
Calculate sum based on given month with SUMIF
Used Functions
Category: Math and trigonometry
Adds the cells specified by a given criteria
Syntax
SUMIF(range, criteria, [sum_range])
Practice SUMIF Formula at Sheetzoom
SUMIF formula at Microsoft help
0
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.