Thread: getting the sum of the last 20 cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default getting the sum of the last 20 cells
Hi,

No need for a macro ...
=SUM(yourcell:OFFSET(yourcell,-20,0))

HTH
Cheers
Carim

Reply With QuoteReply With Quote