Please enable JavaScript to view the comments powered by Disqus.


Calculate sum based on given month with SUMIF

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. 

Used Functions

Category: Math and trigonometry

Adds the cells specified by a given criteria


SUMIF(range, criteria, [sum_range])

Lets chat on this