Forum Discussion
Panonra7660
Feb 17, 2021Copper Contributor
Berechnung Summe ist immer "Null" Excel on Mac
In meiner Tabelle steht bei der Berechnung der Summe immer 0,00 - was kann ich machen - Format ist auf "Zahl" gestellt
4 Replies
Sort By
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.
- Panonra7660Copper Contributor
verwendete Formel - =Summe(O30:T30) - Ergebnis korrekt
Formel : =Summe(O30:T30;B30:L30) - Ergebnis 0,00
Zellenformat: Zahl eingestellt
Can you attach a sample workbook without sensitive data?