Forum Discussion
@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...
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(
Which version of Excel are you using?
In my desktop version of Excel in Microsoft 365 for Windows, @SUM(A1:A3) is automatically converted to =SUM(A1:A3).
But in Excel Online (in the browser), @SUM is not recognized, and results in #NAME!
