You would need to switch ON that function previously.

Why is sum function in excel not working. What To Do If Excel SUMIF Is Not Working. From your keyboard press CTRLH This will open the find and replace dialog box on your screen. 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.

Apache OpenOffice 341 on Windows 7. You might also run into drag-to-fill issues if youre filtering. Why is my excel sum function not summing correctly.

I would consider this a workaround though it would be better to find a way to get your figures into a valid number format. If youre still having an issue with drag-to-fill make sure your advanced options File Options Advanced have Enable fill handle checked. Cells that are being added together are formatted as numbers.

Choose the dates in which you are getting the Excel not recognizing date format issue. Say one of your cells in the range is A2 try a formula in another cell ISNUMBERA2. This is a very irritating issue and there are no particular reasons behind facing the COUNTIF function not working.

Then format it as Numeric. This happens when Excel has been configured to NOT update formulas automatically. The make Excel automatically calculate formulas again.

However if you type 1000 it will remain as text. This is a common issue related to many other Excel functions like SUMIF SUMIFS COUNTBLANK etc. With Excel open click on the File menu.