Thread: Averaging Cells without an Error
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Averaging Cells without an Error
=AVERAGE(IF(NOT(ISERROR(D2:D16)),D2:D16,))

insert with CTRL+SHIFT+ENTER not just ENTER

maybe this is yr problem
Reply With QuoteReply With Quote