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