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

How about AVERAGE?
=AVERAGE(A1:A12)
If you really want a two-step use =SUM(A1:A12)/COUNT(A1:A12)

best wishes
Bernard

"ryangruhn" wrote in message
...

How do I calculate average values using arithmetic? What I want to do
is take for example A1-A12 and sum them up and divide them by 12 but I
don't know of the function I can "type" in to do so.

Let Me Know!


--
ryangruhn
------------------------------------------------------------------------
ryangruhn's Profile:
http://www.excelforum.com/member.php...o&userid=16037
View this thread: http://www.excelforum.com/showthread...hreadid=274997