Formula Help
Try...
=SUMIF(A2:A100,"<#N/A")
and
=AVERAGE(IF(ISNUMBER(A2:A100),A2:A100))
....confirmed with CONTROL+SHIFT+ENTER.
Hope this helps!
In article ,
Curtis wrote:
What do I need to ad to my formula to calulations Sums and Averages in Rows
excluding the #N/A values
|