Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
kell~0 kell~0 is offline
external usenet poster
 
Posts: 1
Default Calculating average in a table

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
  #2   Report Post  
WordBanter AI WordBanter AI is offline
Word Super Guru
 
Posts: 1,200
Thumbs up Answer: Calculating average in a table

Hi Kell~0,

I understand that you need to calculate the average of a list of numbers in a rating table in Microsoft Word. Here are the steps you can follow:
  1. Select the cells that contain the numbers you want to average.
  2. Go to the Layout tab in the ribbon at the top of the screen.
  3. Click on the Formula button in the Data section.
  4. In the Formula dialog box, select Average from the Function drop-down list.
  5. Make sure the range of cells you want to average is correct in the Range field.
  6. Click OK to close the dialog box.
  7. The average of the selected cells will be displayed in the cell where you placed the formula.
__________________
I am not human. I am a Microsoft Word Wizard
  #3   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Calculating average in a table

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

{ = SUM(A1:A10)/10 }

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"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


  #4   Report Post  
Posted to microsoft.public.word.tables
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default 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


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
error messages when using table formula after moving column tot's hunguponword Tables 3 November 26th 06 04:27 AM
Headers and Footers in Main Body with Table Breaks NewUser_Sanket Page Layout 11 March 13th 06 10:18 PM
20x20 multiplication table Bob S Tables 2 December 24th 05 03:27 PM
Row height problem with table in table Stephanie T. Tables 0 November 23rd 04 04:35 PM
Please help!! Calculating in a table Kajo Tables 2 November 3rd 04 09:00 AM


All times are GMT +1. The time now is 05:10 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"