Calculating average in a table

K

kell~0

Okay, I'll try to make this as clear as I can. Please ask any related
questions. I wish we could have built this form in excel.

This is a performance evaluation. The evaluator will enter a number in one
of 10 objective tables, that number will populate into the corresponding cell
in the rating table. They would like the average of the list of numbers in
the rating table to calculate.

Our IT security policy will not allow macros.

Kell~0
 
S

Suzanne S. Barnhill

Okay, let's say your 10 numbers are in cells A1 to A10. The formula you need
would be:

{ = SUM(A1:A10)/10 }
 
M

macropod

Hi Kell,

If there are no gaps in the table between the 'average' row and the first row, you could use a formula field coded as:
{=AVERAGE(ABOVE)} or {=AVERAGE(BELOW)} to average the column; or
{=AVERAGE(LEFT)} or {=AVERAGE(RIGHT)} to average the row
Put the formula at the bottom, top, right or left, respectively.

If there are gaps in the range, you could use a formula field coded as:
{=AVERAGE(A1,A3, A5,A7,A9)} or {=AVERAGE(A1,A3, A5:A9)} or {=AVERAGE(A1,A3:A4, A6:A9)}
where:
.. 'A1,A3, A5,A7,A9' lists the individual cells;
.. 'A3:A9' lists the range of cells; and
.. 'A1,A3:A4, A6:A9' lists a combination of individual cells and ranges,
to be averaged.

Cheers

--
macropod
[MVP - Microsoft Word]


| Okay, I'll try to make this as clear as I can. Please ask any related
| questions. I wish we could have built this form in excel.
|
| This is a performance evaluation. The evaluator will enter a number in one
| of 10 objective tables, that number will populate into the corresponding cell
| in the rating table. They would like the average of the list of numbers in
| the rating table to calculate.
|
| Our IT security policy will not allow macros.
|
| Kell~0
 
Top