ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Calculating Average Values Using Arithmetic Equations (https://www.excelbanter.com/excel-worksheet-functions/5620-calculating-average-values-using-arithmetic-equations.html)

ryangruhn

Calculating Average Values Using Arithmetic Equations
 

Bernard Liengme Wrote:
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



That worked wonders!!! THANKS!


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



All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com