Hi All,

I'm just having a bit of an issue with the attached workbook.

I have to total 2 cells from all 135 stores into the Pallets Out cell. I've been using the code that is in there currently, however when I go to add more stores it is constantly erroring. Could it be that there is a limit?

Any ideas on how to get past this error?DULUX PALLETS FY2015(1).xlsm