A couple of other ways.

1
To sum A1:A115
In A116 press Alt and = together
let go then hit enter

2
Highlight A1:A115
And look at the status bar at the bottom right of your screen
You may have to right click on the status bar and check sum first.

HTH
Martin



"Anthony B" wrote in message
...
How to quick calculate sum of colume A1 to A115?

Or, do I always have to set up formular =sum(A1:A15) to get the sum?