Please suggest a required formula for the attached sheet

[Kumar@raja]

Hi Friends,


Kindly help me out to get the required formula for the attached sheet.

Here I wanted to consolidated the amount against respective month in column D which is capturing the data from B.

Thank in advance for the support
Kumar

 

[chirayu]

=SUM(IF(TEXT(A:A,"mmmm")=D3,B:B))

Use CTRL + Shift + Enter after you put formula in cell then drag down

 

[Chihiro]

Sumproduct method:
=SUMPRODUCT((MONTH($A$2:$A$222)=MONTH(D3&" 1"*1))*($B$2:$B$222))

SUM(IF()) Array:
=SUM(IF(MONTH($A$2:$A$222)=MONTH(D3&" 1"*1),$B$2:$B$222))
Confirmed as array (CSE)

Edit: Forgot the text function. Using chirayu's method Sumproduct one will be...
=SUMPRODUCT((TEXT($A$2:$A$222,"mmmm")=D3)*($B$2:$B$222))

However since OP's sheet had trailing space... used TRIM on D3.
=SUMPRODUCT((TEXT($A$2:$A$222,"mmmm")=TRIM(D3))*($B$2:$B$222))

 

[Biplab4444]

Hi.......
You may also create Pivot Table and and group date in months....

 

[David Lam]

Please find attached. Could merge them into 1 formula like the guys above.

 

[Naresh Yadav]

pls try this one..

=SUM(MMULT((MONTH($A$2:$A$222)=MONTH(D3&1))*($B$2:$B$222),1))

 

[Biplab4444]

Hi...
Please find the attached file.......

 

[Kumar@raja]

Dear Friends,

Thank you very much for taking time to provide the suitable formula.

Thanks a lot.
Kumar