View Single Post
  #2   Report Post  
Posted to microsoft.public.word.tables
Jean-Guy Marcil
 
Posts: n/a
Default averages in word table

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?


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
ISTOO
Word MVP site:
http://www.word.mvps.org