Sumifs or Sumproduct

[uswyne]

Entry

Admission Fee	Security Deposit	Tution Fee	Computer Fee	Total Amount	Paid Date
25000	25000	20000	2000	72000	2/25/18
0	25000	11000	1000	37000	3/1/18
25000	25000	22000	2000	74000	2/15/18

<tbody>
</tbody>

Report

Head	Feb	Mar
Admission Fee	50000	formula required
Security Deposit	50000	formula required
Tution Fee	42000	formula required
Computer Fee	4000	formula required

<tbody>
</tbody>

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.