View Single Post
  #3   Report Post  
neopolitan
 
Posts: n/a
Default


Are all these directions from the same quadrant or within 90 degrees
(min/max)? Not sure how useful an average will be if they vary more
than that.

ANYWAY...
Assuming that your data set is in col A, use the AVERAGE function in a
formula in a separate cell; ie: =AVERAGE(A2:A10). If you precede this
with the Round function, you can eliminate the decimal fraction as
well: =ROUND(AVERAGE(A2:A10),0).


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=475877