Why does not summing up from different sheet work?

[Kh1978]

I have different sheets in an Exceldocument and on the first sheet I need to add up the same cell in many sheets. When trying to use this formula below, it does not seem to work.
Note that it is in Swedish so equivalent to Sum and Blad= Sheet

=SUMMA(BladPL1051:BladPL1055!C24)
Also tried for to write =SUMMA(Blad9:Blad12!C24) without having the new name PL1051 to PL1055 and it still does not work
The Cell C24 in the sheets PL1051:PL1055 has a formula adding up different numbers such a =SUMMA(C1:C23) for each separate sheet.

I also tried to just write the formula on new empty sheets and it worked!
=SUMMA(Blad1:Blad3!C24) . So why is it that it works with empty sheets when only putting a number on the same cell C24 on each sheet?



Does it have something to do with the formulas in the sheets för PL1051:PL1055?

Please help me solve this problem!
Thanks
K

[Pecoflyer]

Hi and welcome
If your sheets are called PL1051 to PL1055 you do not have to add "blad"
=SUMMA(PL1051:PL1055!C24)should do.
But the easiest way to enter 3D formulas is to use the technique explained here