Combining list of Unique Values from Multiple Columns and with Total Value

Hi Everyone!

Sample data is attached. I would like preferably a macro to generate a Unique Value list on a separate worksheet and perform SUM of all values matching that unique value. For example, for Acura ILX model with 1.5 engine it should first generate it as a unique value on separate worksheet and than SUM all values matching this criteria:

Make Model Disp
Acura ILX 1.5

As per attached data it should generate as below

Make Model Disp Value
Acura ILX 1.5 114


There are some blanks in the list as well but in all cases Column A & D will always have a value.


Thanks

How did you get 114? What is/are the unique column/s?

Its in sample file. Its sum of example mentioned in my post. Column A,B,C have duplicate values.

No, you have not answered my question. Do you mean 91 or 396?

Sorry I didn't get your question. If you manually filter sample file with with below,you will get sum of value as 114.
Make Model Disp
Acura ILX 1.5

Thank you so much. Its perfect

In case you want to match 3 columns, I have amended post no 6

Thanks a lot!