Sum Unique Values based on Criteria

[Abdur_rahman]

Hello again,

I have adopted below formula and change as per my requirement.

It is working good but the only issue i struck with is it is excluding the repeated amount which is in Column J.

The formula is making sum for unique values but excluding the repeated amount. But i need to include duplicate amounts for a unique value.

Please Login or Register  to view this content.

Appreciate your help...

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

[Abdur_rahman]

Thanks for the response.

I have attached a workbook as requested. Formula need to in column D. Each colour having the amount sample.

[CARACALLA]

D2=IF($A2<>"",SUMIFS($I$2:$I$100,$A$2:$A$100,$A2,$B$2:$B$100,$B2),"")


Copy down

[wk9128]

Cell D2 formula , Drag down

[Abdur_rahman]

Thanks to both of you wk9128 and CARACALLA. it works.
I am closing the topic and reputation added.

[wk9128]

@Abdur_rahman You're Welcome. Glad to help . Thank You for the feedback