Sumif formula help

[ImranBhatti]

Hello

I have a sheet with 3 columns
Column A consists of invoices numbers
Column B consists of customers name
Columns C consists of their balance amounts

every invoice is mentioned as many times as there will be items per invoice that is why the invoice number needs to be repeated

If a customer have invc#1,1,1 I and 2,2,2 I only want to sum the balance of 1 and 2 .Its little bit difficult for me to explain in writing .I thing the attached workbook with desired results manually put will help you guys what I need.

Best Regards
Imran Bhatti

[José Augusto]

Try in B19 and copy down

Please Login or Register  to view this content.

[CK76]

So what's the expected result?

Is it 5395 for "Mr" or should it be 2545?

If latter use following in B19:
=SUMPRODUCT(($B$2:$B$16=A19)/COUNTIF($A$2:$A$16,$A$2:$A$16&""),$C$2:$C$16)

But "Mis" has 2 different balance for Invoice #4. Is this typo or intended?

[ImranBhatti]

So what's the expected result?

Is it 5395 for "Mr" or should it be 2545?

If latter use following in B19:
=SUMPRODUCT(($B$2:$B$16=A19)/COUNTIF($A$2:$A$16,$A$2:$A$16&""),$C$2:$C$16)

But "Mis" has 2 different balance for Invoice #4. Is this typo or intended?

Expected result for Mr is yes 2545
Yes Invoice #4 there is a typo

Your formula solved the problem

Thanks

Best Regards
Imran Bhatti