Thread: "num#" errors .. how to average a group with a "num#" error
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default "num#" errors .. how to average a group with a "num#" error
=SUMIF(C1:C13,"<1E100")/COUNTIF(C1:C13,"<1E100")


"Byron" wrote:

doing a monte carlo simulation and many times it will register an error
specifiaclly a num# error .. I then average and do other stuff to the
calculations, and it doesnt work with those num# I have tried =iferror(
but that doesnt work for num#

help
Reply With QuoteReply With Quote