Thread: summing the values in nonblank cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Krill Nick Krill is offline
external usenet poster
  
Posts: 19
Default summing the values in nonblank cells
I need to find a way to sum the last 10 nonblank values in a column of
numbers. There may be a random dispersal of blank cells in the column, but I
need to sum the last 10 values of real numbers no matter the cell range.
Reply With QuoteReply With Quote