averages in word table

W

weim10

I'm trying to create an evaluation form using a table in Word. In the
middle of the table is a section with ten rows and eight columns in which the
1st column is a lable, columns 2-6 are numerical values (for daily scores) or
empty and the 7th column is an average in which the sum is divided by the
number of cells in the row that actually have a numeric value in them because
some of the cells will be empty if a particular activity is not observed on a
certain day.
Is this possible, without using Macros?
 
J

Jean-Guy Marcil

weim10 was telling us:
weim10 nous racontait que :
I'm trying to create an evaluation form using a table in Word. In
the middle of the table is a section with ten rows and eight columns
in which the 1st column is a lable, columns 2-6 are numerical values
(for daily scores) or empty and the 7th column is an average in which
the sum is divided by the number of cells in the row that actually
have a numeric value in them because some of the cells will be empty
if a particular activity is not observed on a certain day.
Is this possible, without using Macros?
Click to expand...

Probably, but you will need fairly complicated formula (Where is Macropod?)

It would be a lot easier in Excel.
Set it up in Excel (Ask for the fairly simple formula in the Excel group)
and then copy/paste the table in Word using Edit > Paste Special > Link so
that whenever you update the values in Excel, they will update in Word.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
[email protected]
Word MVP site: http://www.word.mvps.org
 
T

Tony Jollans

An AVERAGE Formula Field will do this.

In the seventh column of row 1, say, insert a formula field containing
=AVERAGE(b1:f1) and this will give the average of the numeric values in
cells 2 through 6 of row 1.

You'll need to adjust the cell references to include the cells you want (I
can't tell precisely from your post).
 
S

Suzanne S. Barnhill

The trick is that he wants to include only the cells that have values, and
there's no way to determine that except manually or with some sort of macro.
I gather that he knows how to do it manually but wants to automate the
process.

Okay, I just tried this, and it seems that the AVERAGE function does in fact
ignore empty cells, so it should work.
 
J

Jean-Guy Marcil

Tony Jollans was telling us:
Tony Jollans nous racontait que :
An AVERAGE Formula Field will do this.

In the seventh column of row 1, say, insert a formula field containing
=AVERAGE(b1:f1) and this will give the average of the numeric values
in cells 2 through 6 of row 1.

You'll need to adjust the cell references to include the cells you
want (I can't tell precisely from your post).
Click to expand...

Who knew Word was so smart!
I did not know that AVERAGE ignored non numerical values.

But make sure that your "empty" cells do not have a numerical date, a 0 or a
negative number, etc.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
[email protected]
Word MVP site: http://www.word.mvps.org
 
Top