Sumifs or Sumproduct

[uswyne]

Entry

[TABLE="width: 500"]
<tbody>[TR]
[TD]Admission Fee[/TD]
[TD]Security Deposit[/TD]
[TD]Tution Fee[/TD]
[TD]Computer Fee[/TD]
[TD]Total Amount[/TD]
[TD]Paid Date[/TD]
[/TR]
[TR]
[TD]25000[/TD]
[TD]25000[/TD]
[TD]20000[/TD]
[TD]2000[/TD]
[TD]72000[/TD]
[TD]2/25/18[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]25000[/TD]
[TD]11000[/TD]
[TD]1000[/TD]
[TD]37000[/TD]
[TD]3/1/18[/TD]
[/TR]
[TR]
[TD]25000[/TD]
[TD]25000[/TD]
[TD]22000[/TD]
[TD]2000[/TD]
[TD]74000[/TD]
[TD]2/15/18[/TD]
[/TR]
</tbody>[/TABLE]

Report

[TABLE="width: 500"]
<tbody>[TR]
[TD]Head[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[/TR]
[TR]
[TD]Admission Fee[/TD]
[TD]50000[/TD]
[TD]formula required[/TD]
[/TR]
[TR]
[TD]Security Deposit[/TD]
[TD]50000[/TD]
[TD]formula required[/TD]
[/TR]
[TR]
[TD]Tution Fee[/TD]
[TD]42000[/TD]
[TD]formula required[/TD]
[/TR]
[TR]
[TD]Computer Fee[/TD]
[TD]4000[/TD]
[TD]formula required[/TD]
[/TR]
</tbody>[/TABLE]

Kindly help me on this.

 

[lrobbo314]

You may have to adjust dome of the ranges depending on where your data is, but this formula seems to do what you are looking for.

=SUMPRODUCT(($A$2:$E$4)*(TEXT($F$2:$F$4,"mmm")=B$7)*($A$1:$E$1=$A8))

 

[uswyne]

Thanks for your reply.

what if i need report yearwise. Like Feb-18

You may have to adjust dome of the ranges depending on where your data is, but this formula seems to do what you are looking for.

=SUMPRODUCT(($A$2:$E$4)*(TEXT($F$2:$F$4,"mmm")=B$7)*($A$1:$E$1=$A8))

 

[uswyne]

moreover this formula works on sample file but not in original file i am looking whats going wrong.