Index Match multiple Sum

Okay let me remake my example again.
I made it too simple for my question.

On my spread sheet insurer capacity, it looks up master list by using index match but some accounts have the same insurer and i need to add it up. I am not sure how to do it with index match.
I do it this way because it actually looks at multiple master and then pull from it but for sake of simplicity just look up one master. I would like to know how to index match sum multiple results in a single cell (if that is even possible).

In my example:
Using index match, AAA is only showing 10 from account A (Cell 'Insurer Capacity'!B2)
I want index match (or other possible formula) to show total % of AAA in account which should be 15 instead.

Thanks

Give this a try

=SUMIF(C2:G2,"Toyota",D2:H2)

In B2 copied to the right and down...

=SUMIF(Master!$C2:$O2,B$1,Master!$D2:$P2)

With the two account list are not in same order, try in B2:

Please Login or Register  to view this content.

Drag down and accross