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

Excluding only leading or trailing cells from a column

You've explained about excluding the leading cells A1:A3 but what do you
mean when you say exclude trailing cells? What trailing cells?

--
Biff
Microsoft Excel MVP


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