Thread: Excluding only leading or trailing cells from a column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Excluding only leading or trailing cells from a column
Or possibly =SUM($A$4:INDEX(A:A,ROW()-1))


Gord Dibben MS Excel MVP

On Sun, 21 Oct 2007 13:47:06 -0300, "Bernard Liengme"
wrote:

Would =SUM(A:A)-SUM(A1:A3) work?
best wishes

Reply With QuoteReply With Quote