Create Summaries Based on Conditions

[Exterior]

I wanting to create summaries of every product that is both the same size and color. Below are 3 simple examples showing both the original data and the resulting summary I wish to create. Can someone please tell me what formula I should use to create this?

P.S. It's not necessary to merge cells as I've done for the amounts below. Not even sure why I did that actually.

 

[Maverick27]

You need to create Excel list as shown in example below.

[/URL][/IMG]

Then, in order to Summarise the data, you need to use Pivot Table Feature.

Select Range of Data to summarise, goto Insert > Pivot Table.

Watch Beginners Tutorial below on how to use Pivot Tables.

https://www.youtube.com/watch?v=peNTp5***Fg