Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Error in AVERAGE results
In Word 2003, I have created an evaluation form which has several separate
tables for each area being evaluated. The score of each area is placed in the last cell of each table. The score is a text form field as a number between 1 and 3 or left blank. At the end of the form I have placed another table for evaluation results. In that table I am trying to average the scores using a formula. Unfortunately the formula counts the blank fields when it is averaging, thus giving an incorrect answer. My formula is simply this; =AVERAGE(score1,score2,score3,score4,score5) Any suggestions how to fix this would be greatly appreciated. -- Charlie |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Error in AVERAGE results
{ = (score1 + score2 + score3 + score4 + score5)/{ = ({ IF score1 0, 1,
0 } + { IF score2 0, 1, 0 } +{ IF score3 0, 1, 0 } +{ IF score4 0, 1, 0 } +{ IF score5 0, 1, 0 }) } } -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Charlie Brown" wrote in message ... In Word 2003, I have created an evaluation form which has several separate tables for each area being evaluated. The score of each area is placed in the last cell of each table. The score is a text form field as a number between 1 and 3 or left blank. At the end of the form I have placed another table for evaluation results. In that table I am trying to average the scores using a formula. Unfortunately the formula counts the blank fields when it is averaging, thus giving an incorrect answer. My formula is simply this; =AVERAGE(score1,score2,score3,score4,score5) Any suggestions how to fix this would be greatly appreciated. -- Charlie |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Error in AVERAGE results
Thanks for your reply, Doug.
I entered this formula in the cell and get a syntax error after update. Then I verified I had typed it correctly to what you have given but kept getting the syntax error. It took me a while of messing with it, but what I found was the IF statements do not use commas. Once I removed them it worked; I.E. { IF score1 0 1 0}. Thanks again! -- Charlie "Doug Robbins - Word MVP" wrote: { = (score1 + score2 + score3 + score4 + score5)/{ = ({ IF score1 0, 1, 0 } + { IF score2 0, 1, 0 } +{ IF score3 0, 1, 0 } +{ IF score4 0, 1, 0 } +{ IF score5 0, 1, 0 }) } } -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Charlie Brown" wrote in message ... In Word 2003, I have created an evaluation form which has several separate tables for each area being evaluated. The score of each area is placed in the last cell of each table. The score is a text form field as a number between 1 and 3 or left blank. At the end of the form I have placed another table for evaluation results. In that table I am trying to average the scores using a formula. Unfortunately the formula counts the blank fields when it is averaging, thus giving an incorrect answer. My formula is simply this; =AVERAGE(score1,score2,score3,score4,score5) Any suggestions how to fix this would be greatly appreciated. -- Charlie |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Error in AVERAGE results
Sorry for the bum steer there. Too much time spent working in Access and
Excel where commas are used. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Charlie Brown" wrote in message ... Thanks for your reply, Doug. I entered this formula in the cell and get a syntax error after update. Then I verified I had typed it correctly to what you have given but kept getting the syntax error. It took me a while of messing with it, but what I found was the IF statements do not use commas. Once I removed them it worked; I.E. { IF score1 0 1 0}. Thanks again! -- Charlie "Doug Robbins - Word MVP" wrote: { = (score1 + score2 + score3 + score4 + score5)/{ = ({ IF score1 0, 1, 0 } + { IF score2 0, 1, 0 } +{ IF score3 0, 1, 0 } +{ IF score4 0, 1, 0 } +{ IF score5 0, 1, 0 }) } } -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Charlie Brown" wrote in message ... In Word 2003, I have created an evaluation form which has several separate tables for each area being evaluated. The score of each area is placed in the last cell of each table. The score is a text form field as a number between 1 and 3 or left blank. At the end of the form I have placed another table for evaluation results. In that table I am trying to average the scores using a formula. Unfortunately the formula counts the blank fields when it is averaging, thus giving an incorrect answer. My formula is simply this; =AVERAGE(score1,score2,score3,score4,score5) Any suggestions how to fix this would be greatly appreciated. -- Charlie |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating average in a table | Tables | |||
Average calculation | Microsoft Word Help | |||
mean or average symbol | Microsoft Word Help | |||
what is an antonym for average | Microsoft Word Help | |||
Not your average Word column question - help! | Microsoft Word Help |