Match 2 Criteria on multiple sheet and return a value

[Yvonne Ng]

I have data sheet namely Sept, Oct.
I want to create a summary page to see how much I've been bill on that particular invoice.
I try used index and match function for multiple sheet, but not successful.

Please illustrate and advise.
Attached file for reference.

 

[BigBeachBananas]

=IFNA(INDEX(Sept!$C$2:$C$4,MATCH(A2&B2,Sept!$A$2:$A$4&Sept!$B$2:$B$4,0)),0)
Its work for the data search for sept, but i try add for oct , the formular :
=IFNA(INDEX(Sept!$C$2:$C$4,MATCH(A3&B3,Sept!$A$2:$A$4&Sept!$B$2:$B$4,0))+INDEX(Oct!$C$2:$C$4,MATCH(A3&B3,Oct!$A$2:$A$4&Oct!$B$2:$B$4,0)),0)
Giving me A '0'. how should i corrrect the formula for the other months?

You're missing IFNA for Oct

 

[Yvonne Ng]

You're missing IFNA for Oct

=IFNA(INDEX(Sept!$C$2:$C$4,MATCH(A4&B4,Sept!$A$2:$A$4&Sept!$B$2:$B$4,0)),0)+IFNA(INDEX(Oct!$C$2:$C$4,MATCH(A4&B4,Oct!$A$2:$A$4&Oct!$B$2:$B$4,0)),0)+IFNA(INDEX(Nov!$C$2:$C$4,MATCH(A4&B4,Nov!$A$2:$A$4&Nov!$B$2:$B$4,0)),0)

i guest i got it...
just that to confirm I have to use a "+" for every month formula to add on ya?

 

[BigBeachBananas]

=IFNA(INDEX(Sept!$C$2:$C$4,MATCH(A4&B4,Sept!$A$2:$A$4&Sept!$B$2:$B$4,0)),0)+IFNA(INDEX(Oct!$C$2:$C$4,MATCH(A4&B4,Oct!$A$2:$A$4&Oct!$B$2:$B$4,0)),0)+IFNA(INDEX(Nov!$C$2:$C$4,MATCH(A4&B4,Nov!$A$2:$A$4&Nov!$B$2:$B$4,0)),0)

i guest i got it...
just that to confirm I have to use a "+" for every month formula to add on ya?


View attachment 99973

Yes.

 

[Yvonne Ng]

Yes.

Great.
Thank you so much for your advise,