View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PaladinWhite PaladinWhite is offline
external usenet poster
 
Posts: 29
Default Excluding only leading or trailing cells from a column

D'oh - I can't believe something that simple eluded my grasp. That's
precisely what I need to do. Thanks.

"Bernard Liengme" wrote:

Would =SUM(A:A)-SUM(A1:A3) work?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"PaladinWhite" wrote in message
...
I have a column, say A, that I want to SUM(). I want to avoid including
A1:A3
in this sum - unfortunately, the length of the data in the column at any
time
is indeterminate. So I can't SUM(A4:AX)... And I can't SUM(A4:A), although
that seems intuitive to me.

Help?