G Guest Jun 9, 2006 #1 What do I need to ad to my formula to calulations Sums and Averages in Rows excluding the #N/A values
What do I need to ad to my formula to calulations Sums and Averages in Rows excluding the #N/A values
D Domenic Jun 9, 2006 #2 Try... =SUMIF(A2:A100,"<>#N/A") and =AVERAGE(IF(ISNUMBER(A2:A100),A2:A100)) ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps!
Try... =SUMIF(A2:A100,"<>#N/A") and =AVERAGE(IF(ISNUMBER(A2:A100),A2:A100)) ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps!
G Guest Jun 9, 2006 #3 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...
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...
