Consolidatation with two conditions

[loverfellow]

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.

 

[Chantty]

Try Pivot na!

 

[DonkeyOte]

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]

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]

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]

lasw10,
If this is the case then please tell me how I can use the method (not Pivot table) to obtain the result.