This can be very confusing and you might think youve somehow broken your spreadsheet.

Why is my sum function in excel not working. I have some cells that are formatted as Number all with values 0 but when I use the standard SUM on them it always shows a result of 00 instead of the correct sum. Try removing all filters and dragging again. If for any reason the SUMIF function is not working no matter what you do use an alternative formula.

How to fix this issue. You accidentally enabled Show Formulas. Im stumped in Excel version 160 Office 365.

If youre still having an issue with drag-to-fill make sure your advanced options File Options Advanced have Enable fill handle checked. Here this formula uses SUMPRODUCT function. If you try to do a sum youll get an error eg.

With a little troubleshooting you can get things working again. Then with the column still highlighted go to the Data menu and select Text to Columns and click Finish. Reason 5 Check If Formulas are Enclosed in Double Quotes.

Sounds like your values are entered as Text and not Numeric if they are left justified when there is no justification set that is a dead give-away. You might also run into drag-to-fill issues if youre filtering. You can then perform a sum on it.

However if you type 1000 it will remain as text. Its nothing to do with ISTEXT it only to be sure do you have text in the cell returns TRUE or not returns FALSE. When I use instead the sum shows correctly.