ExcelBanter - How do I enter an Average Formula?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I enter an Average Formula? (https://www.excelbanter.com/excel-discussion-misc-queries/110050-how-do-i-enter-average-formula.html)

How do I enter an Average Formula?

real simple, what is the formula for averages

Gord Dibben

How do I enter an Average Formula?

=AVERAGE(A1:A10)

=AVERAGE(1,2,3,4,5,6,7)

Gord Dibben MS Excel MVP

On Thu, 14 Sep 2006 14:19:02 -0700, D. wrote:

real simple, what is the formula for averages

Ricter

How do I enter an Average Formula?

Look at Average worksheet function in Help.

=Average(A1:A5)

for example...

"D." wrote:

real simple, what is the formula for averages

Dave F

How do I enter an Average Formula?

=AVERAGE(range)
--
Brevity is the soul of wit.

"D." wrote:

real simple, what is the formula for averages

All times are GMT +1. The time now is 07:58 AM.