Sumif duplicate value

[Jeffrey Ting]

Dear all,
Need your help!!!

Column A Column B Column C
111 25 47 (25 + 20 + 2)
222 10 10
111 20 -
333 5 5
111 2 -

If i was not allowed to sort data at the column A, what is the formula should i use in order to get the answer at column C
Column A is product code, column B is the sales amount and column c is the total sales amount for that particular product

Anyone able to help? Thanks

[Haseeb Avarakkan]

Hello Jeffrey, Welcome to the forum.

Try

=SUMPRODUCT((B2:B10<>C2:C10)+0,B2:B10)

[Jeffrey Ting]

Hello Jeffrey, Welcome to the forum.

Try

=SUMPRODUCT((B2:B10<>C2:C10)+0,B2:B10)

Hi Haseeb,
Thanks but i cannot get the answer correctly.

[zbor]

Neither we can see what's wrong from your comment.

[kvsrinivasamurthy]

Pl see attached file .Formula is in C column.

[Jeffrey Ting]

Pl see attached file .Formula is in C column.

Yes, i am able to get it.
Thanks Kvsrinivasamurthy You save my day!