Thread: how to quick calculate sum of colume A1 to A115?
View Single Post
  #2  
Old January 2nd, 2008, 11:36 PM posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
  
Posts: 6,167
Default how to quick calculate sum of colume A1 to A115?
=SUM(A2:OFFSET(A2,MATCH(999999,A:A,1),1))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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?