Consolidatation with two conditions

loverfellow

Board Regular
Joined
Mar 4, 2008
Messages
116
I would give an example to better explain the problem.

Say, I have this data in three columns.

Column A Column B Column C
abc 123 5
abc 123 6
abc 234 7
abc 345 4
def 678 3
def 789 8
def 789 7
geh 455 2
geh 455 3

And, I want to get this result through any mean (preferably without the use of VBA).

Column A Column B Column C
abc 123 11
abc 234 7
abc 345 4
def 678 3
def 789 15
geh 455 5

You see, the column I want to take the sum of is column c depending on the basis of consolidation of column B and C.
Please, help me with this guys. I believe it is possible in excel.
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
Create a Pivot Table based off data in A:C.

Set Row field1 = Column A, Row field 2 = Column B
Set Data field = Sum(Column C)

HTH.
 

loverfellow

Board Regular
Joined
Mar 4, 2008
Messages
116
Well, I have done this thing with the use of a pivot table. All i want to know if this can be done with any other method. Its because i want to explain it to the person who don't want to use the pivot table for this purpose.
 

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
Yes it can be done with other methods however those other methods are far more complex than using a Pivot Table so I'd advise you show the user how to use a Pivot Table as opposed to explaining array formulae / sumproducts.

You may also wish to qualify your posts correctly if certain methods are deemed unacceptable

And, I want to get this result through any mean (preferably without the use of VBA).
 

loverfellow

Board Regular
Joined
Mar 4, 2008
Messages
116
lasw10,
If this is the case then please tell me how I can use the method (not Pivot table) to obtain the result.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,371
Messages
5,595,782
Members
414,020
Latest member
Meghdad

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