Calculating average in a table
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)}
whe
.. '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]
"kell~0" wrote in message ...
| 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
|