Forum Discussion
AutoSum not working
This isn´t working for me because I don´t get the same drop down menu when I click "data". There is no place to hit numbers. What do I do? Margot Rylah
The screenshot that Haytham posted seems to indicate that clicking the Data ribbon gives you an option to change the cell format. This is misleading. Instead, you can either (a) select the range of cells and click the Home ribbon to find the indicated format cells dropdown list or (b) select the range of cells then right-click the range and select Format (near the bottom). Finally, apply either General format or the relevant number format.
Hi Deleted,
I hope you next time to choose more appropriate terms because the term (misleading) is often used for deceptive and intended fraud.
The polite term that you should say is that the screenshot might not be clear enough!
Although I think it is clear enough because all Excel users are supposed to know that selected ribbon tab in the screenshot is the Home tab because it's popular, mostly used, and it's the first tab that appears to the user when he opens Excel.
Regards
Not to be rude, but I too could not follow the screen-shot. I am still having this problem and it is very frustrating.
There is a difference between misleading information and intentionally misleading information. A picture /screenshot/description may be misleading without being intentionally misleading. Only intentionally misleading is fraud. This is not a court, social media, or a financial statement. Misleading is not an accusation but merely indicating that the information displayed will confuse somebody who is stressed and in a hurry to sort a problem out. It is to help you to in future be more careful of the screenshot.
- good lord you're an **bleep**
Deleted , if you'll check screenshort more carefully you see what Home tab is selected.
Yes, I know that. But the starting point of the rightmost arrow seems to indicate that one should start by clicking the Data ribbon and is thus misleading (as is evident from hannaaaase's comment "when I click "data". There is no place to hit numbers").
Not bashing anyone here....just trying to clarify for hannaaaase. SergeiBaklan
Hi. Thank you, I´m still not able to do it though. Because b) i found, but to change to numbers doesn´t seem to work and nothing new happens.Deleted
On your screen shot it almost looks like the sum formula is part of the marked cells to sum.
hannaaaase , could you please check
Win+R, type control international, here additional settings and what is you decimal separator
or simply check =ISTEXT(N1) in any empty cell
OK, that seems to be the problem. I copied currency from another document where the decimal was indicated by a . and not a ,
However, I did format the column to be currency, so Excell should either have changed it or alerted me to the problem!
Excel is fussing because you're not telling what cells to sum. You need a range of cells in your formula. Instead of =SUM(), you need something like =SUM(N2:N20) or whatever your range is.
Auto Sum means you do not have to tell it what ccells to sum. You select the range of cells and click Auto Sum. It does not work!!
Even if you then manually enters the range (i.e. you are using SUM) it still does not add. It gives me mostly R0.00, or nothing at all.
