i have a excel table like the following:

At the end i need a sum of this table like:

650 - 153100 to 279000

100 - 153100 to 251100

20 - 155100 to 279000

For every Debit i want the sum the matching Credit columns. (In this example 500 150 are sumarized because both come from 153100 and go to 279000)

Can i do this in excel (without VBA)?

CodePudding user response：

You could use a pivot table to get the result you need (without going into the construction of the pivot table) ...

There's always someone smarter than me out there that will likely come up with a better solution but either of those options should work for you.