Microsoft Excel Autosum doesn't autosum BS

NVP

Legendary member
37,513 1,978
hey mate .........im pretty familiar with Excel .....autosum usually works ?

i simply left click selected the row and then pressed autosum button ....it should put snswer in lower area ?

s/be ok
 

Attachments

tomorton

Legendary member
8,132 1,215
It never works, its useless. They're just doing it to annoy me personally. It used to work when we had Excel 1.1.1 or whatever it was, never failed. Grrrr.
 
M

member275544

0 0
it could be that in one of your numbers its actually text. that generally throws it out
alternatively the cell you're on isn't the same as the column of numbers you want
those notwithstanding, I have to reluctantly agree with NVP...Excel works all the time for me, and its always a user error if not
you could always send the file and we could happily take a look for you...you miserable old b*********
 

tomorton

Legendary member
8,132 1,215
No, the whole column's formatted as numbers. Its f-ing Microsoft sh1t. This used to work in Excel about 10 years ago. Now its all f-ing fancy knobs and bells and its f-ing Christmas and what's f-ing Theresa May doing anyway?
 
  • Like
Reactions: counter_violent

sminicooper

Experienced member
1,148 327
You may have inadvertently clicked the "show formulas" button. Unclick as shown. Send Bill Gates a Christmas card !

formula.JPG
 

tomorton

Legendary member
8,132 1,215
Blimey, never seen that one before. Thank you. I have tried it as per the diagram but it just makes the columns all wider for some reason. The Autosum thing still doesn't sum.

Its 6 o'clock. I'm going to get a drink.
 

sminicooper

Experienced member
1,148 327
Blimey, never seen that one before. Thank you. I have tried it as per the diagram but it just makes the columns all wider for some reason. The Autosum thing still doesn't sum.

Its 6 o'clock. I'm going to get a drink.
It will make the column wider if your default setting is to "adjust column width to the data contained"; if it's also set to "show formulas" it will make it even wider dependent on the length of the formula. Best thing to do is to open a new blank worksheet and experiment with the "show formula" button on the ribbon – you've probably just got it out of sync. It's almost certainly the reason why you are seeing formulas instead of results (the option is there for good reasons but they turn into bad reasons if you don't need the facility).

You will probably get much better results after a few pints!
 
Last edited:
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock