Merge several rows based on heading

Hi!

I hope somebody can help me with a problem im stuck in:

In my company I want to compare the actual numbers from the accounting system with the budget numbers. The problem is that the budget is much less detailed than the actual numbers. Therefor I need a quick way to merge information from several rows in the accounting report over to one cell in the budget, based on the account number.

In the attached example:

“Accounting report“ is of course the raw data from the accounting system.
The form “classification” determines witch of the account numbers that should be calculated/merged in the “budget vs. actual”
Eg. Sales in period one (marked yellow) should calculate account number 1000, 1100 and 1200 in period one in the accounting report. 435+56+876= 1367.


I really appreciate all help on this!

- Etunges
Example 1.xlsx