Formula Help

C

Curtis

What do I need to ad to my formula to calulations Sums and Averages in Rows
excluding the #N/A values
 
D

Domenic

Try...

=SUMIF(A2:A100,"<>#N/A")

and

=AVERAGE(IF(ISNUMBER(A2:A100),A2:A100))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!
 
C

Curtis

Great!

Thanks

Domenic said:
Try...

=SUMIF(A2:A100,"<>#N/A")

and

=AVERAGE(IF(ISNUMBER(A2:A100),A2:A100))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!
Click to expand...
 
Top