# Consolidatation with two conditions

#### loverfellow

##### Board Regular
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.

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Try Pivot na!

#### DonkeyOte

##### MrExcel MVP
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
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
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
lasw10,
If this is the case then please tell me how I can use the method (not Pivot table) to obtain the result.

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,168,025
Messages
5,856,892
Members
431,837
Latest member
megantang

### 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.

### Which adblocker are you using?

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

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