Thread: How do I calculate an average of the last 5 nonblank cells in a row?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelent excelent is offline
external usenet poster
  
Posts: 695
Default How do I calculate an average of the last 5 nonblank cells in
put 5 in cell B1


"excelent" skrev:

=MID(IF(ROW(A1:A30)=LARGE(IF(ISNUMBER(A1:A30),IF( A1:A300,ROW(A1:A30))),MIN(B1,COUNTIF(A1:A30,"0") )),IF(A1:A300,A1:A30)))

INSERT AND HIT CTRL+SHIFT+ENTER

" skrev:

I am trying to average only the last 5 nonblank values in a row of
cells. Is this possible?


Reply With QuoteReply With Quote