Create Summaries Based on Conditions

Exterior

Board Regular
Joined
Dec 20, 2009
Messages
70
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.

Example_1.png


Example_2.png



Example_3.png
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Maverick27

Active Member
Joined
Sep 23, 2010
Messages
272
You need to create Excel list as shown in example below.

summary.png
[/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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,385
Messages
5,601,331
Members
414,446
Latest member
CRAVIN

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top