If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Scoring or Rating
From a previous post. Thought this example might be easier to understand.
I have an Evaluation Sheet that has four cells of different ratings each represented in a cell per rating: i.e. Cell 1 represents an Excelent rating Cell 2 represents a Good rating Cell 3 represents a Fair rating Cell 4 represents an Unsat rating There are 7 total people rating on the Evaluation Sheet I need to average the scores from the four cells to another cell. The total scores add to 7. Example 1: (Excelent) Cell 1 = 2 (Good) Cell 2 = 1 (Fair) Cell 3 = 2 (Unsat) Cell 4 = 2 or Example 2: (Excelent) Cell 1 = 5 (Good) Cell 2 = 0 (Fair) Cell 3 = 2 (Unsat) Cell 4 = 0 How do I get the average score in Cell 5? Please Help! Thanks, JamesZ Last edited by JamesZ : June 20th, 2010 at 04:53 AM. |
Thread Tools | |
Display Modes | |
|
|