Thread: Excluding only leading or trailing cells from a column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default Excluding only leading or trailing cells from a column
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?


Reply With QuoteReply With Quote