Professor Excel

Comments 3

  1. panuffel

    Hi Hendrik, thanks for the post. I stumbled over a fourth option: I had my cells display only one decimal place. The sum in the status bar uses the complete numbers and thus for some cases let to different results.

  2. Tony


    I have this issue where there is a difference of around 1000 between the sum in status bar and a formula. All cells are formatted the same way, numeric and there are no hidden rows. Also if i copy the values and paste them in another sheet, the status bar gives correct result but nothing helps for the sheet where i need it. Any idea what might be the issue?

  3. Richard

    The Excel status bar will not give results for only one item in a column. For 2 or more items it works fine.

Leave a comment

%d bloggers like this: