Thread: Rollup the SUM of a column until last non empty Cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default Rollup the SUM of a column until last non empty Cell
that is almost what he meant. what he really meant was probably more like:

=sum(offset(G5,0,0,counta(G5:G65000),1))

--
Regards,
Tom Ogilvy


"GregR" wrote:

Brain meant =sum(offset("G5",0,0,counta("G5:G65000"),1))


Reply With QuoteReply With Quote