Hi,

I have an workbook that is really slow. I've found out that is due to a lot of sumifs with multiple(4) criterias.

The workbook contains of input-data of approx. 12000 rows of data with 50 columns.

Then there is approx. 50 different output tables with 8 rows and 12 columns. The output tables consists of the sumifs-formulas with the four different criterias. In the sumifs-formulas defined names is used, and the defined names/range refer only to the 12000 rows (not the whole column)

Don't want to use a pivot tables because I believe the pivot will not display all 8x12 fields if there is no data in some of the "cross-points". The data from the output tables is also used further in the workbook.

If I change any of the data in the input-table the workbook takes 20 seconds to "recalculate".

Any suggestions to make this workbook faster, otherwise than setting calculation options to manual?