Word table formulae

[Chas A]

hI I have a 5 row single col table consisting of a heading and 4 rows for data and a 5th row for average calculatio
These are the figures in my tabl
Titl
23
64
45
27
When i use the average formula =average(above) it is returning the average equal to 5 rows of numbers instead of 4 it is including the title row also
Please anyone

 

[Greg Maxey]

Chas,

In what row are you placing the expression { =average(above)}. Heading and
4 rows of data? Seems to me that you don't have a fifth row left to hold
it. What are you getting for an answer? If you have a "6" row table with
the heading in the first row, data in rows 2 through 5, then {
=average(above)} in the 6th row should work. If not, try {=average(a2:a5)}.
Field code brackets { } are entered with CTRL+F9

 

[macropod]

Hi Chas,

The result you're getting is because Word is counting
the 'Title' row, as you would see if you used:
{=COUNT(ABOVE)}
which would return 5.

To get around this, you could use:
{=SUM(ABOVE)/(COUNT(ABOVE)-1)}

Cheers

-----Original Message-----
hI I have a 5 row single col table consisting of a

heading and 4 rows for data and a 5th row for average
calculation

These are the figures in my table
Title
235
642
452
274
When i use the average formula =average(above) it is

returning the average equal to 5 rows of numbers instead
of 4 it is including the title row also

 

[BONNIE]

CHAS TRY PUTTING IN THE ACTUAL TABLE RANGE LIKE B1:B12 IN THE PARENTHESIS.