Thread: How do I sum the last 5 nonzero numbers in a row?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
crabatin crabatin is offline
external usenet poster
  
Posts: 3
Default How do I sum the last 5 nonzero numbers in a row?
I have values in a table and want to add a column on the right that will look
to the left at the previous 20 columns and find the last 5 numbers
(rightmost) that are not zero and sum them.
Reply With QuoteReply With Quote