SUM all totals into 1 cell

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

check this Excel specifications and limits

Any idea on a different formula I could use for all sheets to gain the total?

How do you mean?

your SUM(...) has 3250 characters, maybe a little shorter will work
and 128 arguments

could you suggest a formula to go in there?

I need the total of those 2 cells for all 135 stores (135 sheets)

Thanks Ford. I can't really shorten the names to much but understand that unfortunately they are long. I will definitely try what you said. I can't combine them into one sheet, as we need to see each store individually.

I could be wrong about 135 I knew there was a 1 and a 5, but after staring at this sheet for the amount of hours I have, you tend to lose track.

sum(first name of sheet:last name of sheet!D41)+sum(first name of sheet:last name of sheet!F41)

something like: SUM(sheet1:Sheet100!D41)+SUM(sheet1:Sheet100!F41)

Ford, I keep thread open without refreshing, so I couldn't see yours answer

btw, on TOTAL in C14 you've =SUM(C10-C12), enough =c10-c12, and C16: =SUM(C12:C12)/SUM(C10:C10), enough c12/c10
but I can be wrong