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