Thread: how to quick calculate sum of colume A1 to A115?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how to quick calculate sum of colume A1 to A115?
In Namebox type A1:A115 then hit Enter.

Right-click on status bar and "Sum"


Gord Dibben MS Excel MVP

On Wed, 2 Jan 2008 14:51:02 -0800, "Anthony B" wrote:

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?

Reply With QuoteReply With Quote