This might sound pretty basic, but I'm not sure how to go about doing it...I'm an Excel VBA newbie.

I have validation drop downs between specific cell ranges (A3:A9). Based on what is selected, I want to have a number associated with the selected validation option in those cell ranges.

Example:

--- Validation Options ---
Not started
Completed
Not Completed - At Fault
Not Completed - Not At Fault

Let's just say the following is selected:

A3 = Completed
A4 = Completed
A5 = Not Completed - At Fault
A6 = Completed
A7 = Completed
A8 = Not Completed - Not At Fault
A9 = [Blank]

I want to count the total of either "Completed" or "Not Completed - At Fault" (ignoring blanks and the other selections) within A3-A9 and display in another worksheet called "Team 1" within the same workbook in cell A1 the average of "Not Completed - At Fault" to the total count described above. In other words 4/5 = 80%

Can you guys please help!!!????

Thanks!