Numbers - Formula to return values based on specific dates

Before Rockondevil reports that the formula raises a syntax error, here's the corrected version:

in cell D2:

=SUMIFS($B,$A,">="&C2,$A,"<="&EOMONTH(C2,0))

It also makes it copyable without modifications.

Edit: better include the year in entering the months to confirm which year the month is in, if you do this exercise for many years.

You can do this in less than a minute with a Pivot Table. No formulas! Just click and drag.

Click in the data table and from the menu choose Organize > Create Pivot Table > On Current Sheet.

Then in the Pivot Options pane at the right drag the Fields down into the boxes below as shown in the screenshot.

That's all there is to it!

SG

It is possible using SUMIFS and EOMONTH formulas:

Just create it for each month and adjust a range of cells

SUMIFS(B2:B8;A2:A8;">="&DATE(2023;8;1);A2:A8;"<="&EOMONTH("01 Sep 2023";0))