How To Populate Summary Conditionally From 2 Dimension Table?

X

xlmaniac

Well-known Member
Joined
Jul 2, 2009
Messages
528
Office Version
  1. 2010
Platform
  1. Windows
Dear All,
I have a sample data set across A8:H13.
I would like to populate summary across B2:D6(highlighted in yellow) from data set.
Could somebody help me with the formulae across B2:D6?
Regards
1716309519069.png
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
You must log in or register to reply here.

Similar threads

P
  • Question
Complete Summary Table with data from multiple sheets
Replies
6
Views
374
pioshelby1980com
P
Y
  • Solved
Wrong Copy Data from Several Excel file
Replies
8
Views
174
yamixas
Y
B
  • Solved
Populating combobox from table based on the header selected in another combobox (some data on different sheets)
Replies
7
Views
399
BWL388
B
S
  • Question
Auto Sorting League Table
Replies
2
Views
121
arun_eagertolearn
A
E
  • Question
Macro to Pull Summary from Multiple Files
Replies
2
Views
358
dreid1011
dreid1011

Forum statistics

Threads
1,217,367
Messages
6,136,146
Members
449,994
Latest member
Rocky Mountain High

Share this page

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
Back
Top