"num#" errors .. how to average a group with a "num#" error

[Byron]

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

 

[Max]

You could try something like this, array-entered*:
=AVERAGE(IF(ISNUMBER(A2:A100),A2:A100))
*press CTRL+SHIFT+ENTER to confirm the formula

Success? Click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik

 

[Max]

You could try something like this, array-entered*:
=AVERAGE(IF(ISNUMBER(A2:A100),A2:A100))
*press CTRL+SHIFT+ENTER to confirm the formula

Success? Click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik

 

[RagDyeR]

Another way, non-array:

=SUMIF(C1:C13,"<"&99^99)/COUNTIF(C1:C13,"<"&99^99)
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


You could try something like this, array-entered*:
=AVERAGE(IF(ISNUMBER(A2:A100),A2:A100))
*press CTRL+SHIFT+ENTER to confirm the formula

Success? Click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik

 

[RagDyeR]

Another way, non-array:

=SUMIF(C1:C13,"<"&99^99)/COUNTIF(C1:C13,"<"&99^99)
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


You could try something like this, array-entered*:
=AVERAGE(IF(ISNUMBER(A2:A100),A2:A100))
*press CTRL+SHIFT+ENTER to confirm the formula

Success? Click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik

 

[Teethless mama]

=SUMIF(C1:C13,"<1E100")/COUNTIF(C1:C13,"<1E100")

 

[Teethless mama]

=SUMIF(C1:C13,"<1E100")/COUNTIF(C1:C13,"<1E100")