3 Filters Formula

[game_federer]

Dear sirs,
Please help me the following question. Thank you very much.

Each customer in Table IV has multiple accounts. The amount due for the accounts for the first six months of different financial years are provided in the table. The user will enter the Customer Number, the Account Number and the month in the cells, M5, M6 and M7 respectively.

Write a formula in the box provided below to calculate the total amount due for the particular account (value in cell M6) of the customer (value in cell M5) for the given month (value in cell M7). For example, if the user enters C001, 11 and April in M5, M6 and M7 respectively, the correct formula will return 492 {200 (value in H5) + 292 (value in H8)}.
Please note that you cannot change the data in Table IV. You cannot add a row or a column, nor can you sort or filter the data.

Thanks,

 

[Haz]

=SUMPRODUCT((C5:C13=M5)*(D5:D13=M6)*INDEX(E5:J13,,MATCH(M7,E4:J4,0)))

 

[John Jairo V]

Hi, to all!

This could be another option:
=SUMIFS(INDEX(E5:J13,,MATCH(M7,E4:J4,)),C5:C13,M5,D5:D13,M6)

Blessings!

 

[bosco_yip]

If the "Output" set up in Database layout, you can use the IBM Database function of which faster than all Excel functions

In P5, enter :

=DSUM(C4:J13,INDEX(C4:J4,MATCH(O5,C4:J4,0)),M4:N5)

Regards
Bosco

 

[Haz]

You can simplify that
=DSUM(C4:J13, O5, M4:N5)

 

[GVN KUMAR]

You can simplify that
=DSUM(C4:J13, O5, M4:N5)

its very simple and single formula amazing sir