Thread: How to code it in excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelent excelent is offline
external usenet poster
  
Posts: 695
Default How to code it in excel?
=SUM(INDIRECT("C"&SMALL(IF($A$1:$A$1000="",ROW($A$ 1:$A$1000)),ROW()-1)):INDIRECT("C"&SMALL(IF($A$1:$A$1000="",ROW($A$1 :$A$1000)),ROW())))

put in a free cell in row 2 << then CTRL+SHIFT+ENTER
then copy down


Reply With QuoteReply With Quote