Code as alternative for SUM(SUMIF...)

[vendam]

Dear experts,
could you please help me with VBA code what will do the same as very slow matrix:

Please Login or Register  to view this content.

In „Sheet1“ I would like to calculate in cell A1 total weight of loaded boxes found in range „B3:K66“. Boxes details can be found in Sheet2 in Range A1:L, weight is in column I.
Thank you very much.
vendam

Picture.JPG

[TMS]

Just don't use full column references. Use something like

Please Login or Register  to view this content.

with a sufficiently large end row number, or define a couple of Dynamic Named Ranges for columns A and I

So, like this:

Please Login or Register  to view this content.

where
BOX:

Please Login or Register  to view this content.

and
WEIGHT:

Please Login or Register  to view this content.

Note that both are based on the number of rows in column A for consistency

[vendam]

Hello, thank you for help.
In new workbook it´s super fast, in my macroworkbook it´s very slow also.
I have to check all matrix and calculation - as try to improve calculation time.
vendam

[TMS]

You're welcome. Thanks for the rep.