VBA Code: sum the values based on unique values

Hi,
Please find the attached sample data file and I am looking for sample VBA code for below scenario.

My result should display in Column D and I need a sum of values in ColumnB which should come from unique combination of ColumnA and ColumnB.

Example from data file: My result ( ColumnD), For the combination of "AM02" (ColumnA) and "disp_AC_In" (ColumnC) should be 350.

I hope you understood my scenario. Please let me know if you require more details to understand my scenario.

Regards,
Sri

Re: VBA Code: sum the values based on unique values

Hi,

Anyone could you please help me to accommodate this scenario.

Regards,
Sri