Summing Matrix

[danik]

Hello,

I've got a list of fixed size tables containing info about projects.
all the tables are located in the same sheet, one after another (in excel).

I need to summarize them in a table at the same size, where each cell will hold the total of all the cells in his place at the projects tables.

the problem is that i dont know hopw many tables will be (are generated from ERP).

the way i tried to do it was using the array summing, but i dont know how to write a macro that will perform the same action.

Thank you.

 

[GlennUK]

What about a PivotTable report? ( menu command Data/PivotTable ... )