Sum with the condition of Month and Heading..

[Naresh Yadav]

Respected All,

I have a DATA and I need a formula that can allow me get the transpose total sum of the Value with the given Condition

Condition :- Total Sum should be month and Heading Wise

kindly find the attached file with the desired Result..

 

[bosco_yip]

Try,

In E3, formula copy across and down :

=SUMIF($A$20:$A$35,E$2,INDEX($E$20:$R$20,MATCH($D3,$E$19:$R$19,0)))

Regards
Bosco

 

[Deepak]

Put in E3 & Drag below,right

=SUMPRODUCT(($A$20:$A$35=E$2)*INDEX($A$20:$R$35,,MATCH($D3,$A$19:$R$19,0)))

 

[Naresh Yadav]

Respected Deepak/Bosco Sir,

thank you so much...it works perfect the way i wanted..