Forum Discussion
@SUM not working
If I type @SUM at the bottom of this column of numbers (this worked previously), select the range, and hit enter - @sum( is displayed. Thought maybe it was the excel update.
I don't see a way to attach pictures, but this is what the columns look like for each:
=SUM
4
5
9
11
7.5
36.5
@SUM
4
5
9
11
7.5
@sum(
@SUM() works if you ON Lotus compatibility setting (OFF by default) here
With that you may enter @SUM(range) which automatically will be converted to =SUM(range) on Enter.
Please note, setting is applied to the specific sheet in opened file only.
- Thanks so much for this! I've been using @sum() since the earliest days of Lotus 1-2-3 and it is a very difficult habit to change!!
sherrema I just googled this because @sum in Excel just stopped working for me... goes back to Lotus 123 for me too. I have go admit that =sum probably makes more sense.
KarinJeske I know- I’ve started every formula with @ since the mid 80s. It’s been over two months since I’ve had to try to change. I still find myself starting with @ multiple times every day. Crazy how difficult it has been. I wonder how many of us old school Lotus converts are still around and struggling with this. 😎
This solution does not work. I guess I am also ancient in age as I've ALWAYS used the @sum. It is such a habit for me that this all of a sudden not working is extremely annoying!
- Never mind - closed my sheet, re-opened, tried it and it DOES work. Thank you! (too bad it won't stick and I have to remember to do this everytime tho).
DebraP I feel your pain. I began using Lotus123 in the 80's and have always used the @ symbol in excel (and I am somewhat of a master at excel, so no dummy). the @ symbol stopped working for me around a week ago, after another company installation of cloud based Thompson Reuters app, requiring 2FA and update to my MS account. Not only can I not use @, my CTRL/spacebar no longer highlights sections of data before encountering a blank row/column. There are a few other oddities that have not worked but they have been hit and miss and depends on which workbook I am in. It is sooooo frustrating. I cannot type =sum or anyother =formula, my fingers do not work that way!!! No one out there seems to notice as we are too old I guess and very few of us operate this way with @. Its my left hand that moves to hit @ as I'm whizzing thru typing, I cannot make my right hand find =. If I have to retrain my hands I am going to be VERY VERY UNHAPPY! and this still doesnt solve the CTRL/spacebar issue. Turning on the Lotus123 transition box has to be done for each different workbook. Oh how I am not going to do this. It has not been an issue for 40 years, why now??? Hope someone can come up with something or at least a reason why this just started occuring.
- that solved it - thanx 🙂
SergeiBaklando you have an idea how to fix this on Excel on a Mac?
yoyoindigo Long time Mac user myself, though now mostly working on PC. The 'transition formula entry' option is not available on Mac, and I do not recall that you could ever start a formula on a Mac with the @ sign either, contrary to your suggestion in this post starting the formula with @ - Microsoft Community Hub.
- Have been using @sum since the days of the Bondi Blue Macs. And as mentioned, it's just since the upgrade that @sum() no longer works. But I will keep looking until I am forced to concede, and then will just have to adapt to using the proper =sum(). Thanks for your assistance though.
