Berechnung Summe ist immer "Null" Excel on Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-2142734%22%20slang%3D%22de-DE%22%3ECalculation%20sum%20is%20always%20%22zero%22%20Excel%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142734%22%20slang%3D%22de-DE%22%3E%3CP%3EIn%20my%20table%2C%20when%20calculating%20the%20sum%2C%20the%20calculation%20of%20the%20sum%20always%20says%200.00%20-%20what%20can%20I%20do%20-%20format%20is%20set%20to%20%22number%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2142734%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2142756%22%20slang%3D%22en-US%22%3ERe%3A%20Berechnung%20Summe%20ist%20immer%20%22Null%22%20Excel%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142756%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F969422%22%20target%3D%22_blank%22%3E%40Panonra7660%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20Excel%20sees%20the%20values%20as%20text%20even%20though%20the%20cells%20are%20formatted%20as%20numbers.%3C%2FP%3E%0A%3CP%3EThings%20to%20try%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESelect%20a%20column%20with%20such%20values.%20On%20the%20Data%20tab%20of%20the%20ribbon%2C%20click%20Text%20to%20Columns%2C%20then%20click%20Finish.%3C%2FLI%3E%0A%3CLI%3EAlternatively%2C%20select%20an%20empty%20cell%20and%20copy%20it.%20Then%20select%20a%20range%20with%20values%20that%20won't%20sum.%20Click%20the%20lower%20half%20of%20the%20Paste%20button%20and%20select%20Paste%20Special...%3CBR%20%2F%3ESelect%20Add%2C%20then%20click%20OK.%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2142766%22%20slang%3D%22de-DE%22%3ERe%3A%20Calculation%20sum%20is%20always%20%22zero%22%20Excel%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142766%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eformula%20used%20-%20%3Dsum(O30%3AT30)%20-%20result%20correct%3C%2FP%3E%3CP%3EFormula%20%3A%20%3DSum(O30%3AT30%3B%20B30%3AL30)%20-%20Score%200.00%3C%2FP%3E%3CP%3ECell%20format%3A%20Number%20set%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2142778%22%20slang%3D%22en-US%22%3ERe%3A%20Berechnung%20Summe%20ist%20immer%20%22Null%22%20Excel%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142778%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F969422%22%20target%3D%22_blank%22%3E%40Panonra7660%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20you%20attach%20a%20sample%20workbook%20without%20sensitive%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

In meiner Tabelle steht bei der Berechnung der Summe immer 0,00 - was kann ich machen - Format ist auf "Zahl" gestellt

4 Replies

@Panonra7660 

Perhaps Excel sees the values as text even though the cells are formatted as numbers.

Things to try:

  • Select a column with such values. On the Data tab of the ribbon, click Text to Columns, then click Finish.
  • Alternatively, select an empty cell and copy it. Then select a range with values that won't sum. Click the lower half of the Paste button and select Paste Special...
    Select Add, then click OK.

@Hans Vogelaar 

verwendete Formel - =Summe(O30:T30) - Ergebnis korrekt

Formel :  =Summe(O30:T30;B30:L30) - Ergebnis 0,00

Zellenformat:  Zahl eingestellt

@Panonra7660 

Can you attach a sample workbook without sensitive data?

@Hans Vogelaar 

 

Ich habe den Fehler gefunden - ein Zirkelbezug in einer andere Tabelle löste die Nullrechnung aus - leider zeigte Excel diesen Fehler nur als Hinweis beim öffnen der Datei an - erst durch das öffnen der Datei in Numbers (Mac) wurde der Fehler in Tabelle 6 sichtbar - 

Vielen Dank für Ihre Bemühungen