I want to sum data if the date of a cell matches in the current month.

Here is the serie of dates as an example and I want to start to sum data starting from Jan 1.

CodePudding user response：

If you have some dates in column a as shown below, with actual data to sum in column b, and a cell with a date that represents the month/year you wish to sum (Cell e1 in the screenshot), then this formula should give you a summation by the proper month.

=Sum(FILTER(B:B,year(A:A)=YEAR($E$1),month(A:A)=month($E$1)))