Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell 2000 IF Statement
I have a detailed list of training data which tracks course name, date,
instructor and 10 evaluation ratings (e.g.; how well were course objctives met, how knowledgeable was the instructor, etc.). Each rating is a number from 1 to 5. For example: A B C D E F G Course Name Instructor Objectives Knowledge Equipement Registration Ave. Intro to Excel John Smith 2 1 1 2 1.5 Intro to Word Mary Wells 3 2 1 1 1.8 I have a separate summary sheet intended to summarise the course ratings per instructor. For example, I need to calculate the overall course average for each instructor and the number of courses taught by each instructor. Is there a way to use the IF statement so that if the instructor's name is John Smith, the average of all courses assigend to him is returned, along with the total number of courses taught by him? I hope I have provided enough information... Any help is greatly appreciated. Thx, -- LPS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
Excell 2000 | Excel Worksheet Functions | |||
If then statement Excell 2000 | Setting up and Configuration of Excel | |||
Excell 2000 | Setting up and Configuration of Excel | |||
Need Your Help on Excell 2000 | Excel Discussion (Misc queries) |