Forum Discussion
ironhandyman1966
Nov 29, 2023Copper Contributor
@SUM not working
I learned Excel waaaay back. I have always typed in my formulas as @SUM and not =SUM. For some reason the @ version is not currently working. Did Microsoft phase this out? I can't find anything o...
ironhandyman1966
Nov 29, 2023Copper Contributor
If I type =SUM at the bottom of this column of numbers, select the range, and hit enter - the sum of 36.5 is displayed
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(
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(
JoeUser2004
Nov 29, 2023Bronze Contributor
ironhandyman1966 wrote: ``If I type @SUM at the bottom of this column of numbers (this worked previously), select the range, and hit enter - @sum( is displayed [....]``
I don't know if that ever worked the way that you describe literally. But I'm not a fan of "shortcuts". So I'm not very familiar their behavior.
What you describe sounds like the so-called AutoSum operation, sort of. That was moved to the toolbar (ribbon) at least in Excel 2007 (2010) -- maybe even Excel 2003. I cannot remember. Before that, it might have worked as you describe. I don't remember.