Thread
:
how to quick calculate sum of colume A1 to A115?
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett