Need an appropriate formula - Kindly help me out

[Kumar@raja]

Dear Friends,

Kindly suggest me an appropriate formula for the attached sheet. Here, would like to consolidate the month wise figures in G column for all the months.

Please help me in this regard.

Thanks in advance,
Kumar

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[nkms143]

Hi, See if this can help u out.

 

[Kumar@raja]

Hi Naryan & nkms,

Thank you very much for your valued support.

Best,
Kumar

 

[Ashhu]

Hi
one more

{=SUMPRODUCT(IF(MONTH($A$2:$A$25)=MONTH(F4),$C$2:$C$25))}

Its array formula, Press Ctrl+Shift+Enter


Without array

=SUMPRODUCT(--(MONTH($A$2:$A$25)=MONTH(F4)),$C$2:$C$25)

 

[Khalid NGO]

Hi Kumar,

Yet another one (with Pivot)

Regards,