Thread: Formula Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default 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