REVISED Nested IF and Countif ?
Please look here for corrected column references:
Using Excel 2000:
I have one spreadsheet (titled €śevalsecondlang€ť) that contains training
stats. On another spreadsheet in the same workbook, I need to use the data on
evalsecondlang to calculate the number of courses taught by a particular
instructor, on a particular day, in either the morning or afternoon. In
Evalsecondlang, Column D contains the instructors names. Column E contains
the day of the week. Column F contains either Morning or Afternoon. Column H
contains a list of numbers (e.g.; 1, 2, 3 and so on), e.g.;
D E F G H
Catherine Rousseau Monday Afternoon 3
Catherine Rousseau Monday Morning 2
Catherine Rousseau Monday Afternoon 3
Catherine Rousseau Monday Morning 1
Catherine Rousseau Monday Afternoon 3
Georges Farid Thursday Morning 4
Georges Farid Thursday Morning 3
Georges Farid Thursday Morning 4
Georges Farid Thursday Morning 3
Isabelle Poulin Thursday Morning 2
Isabelle Poulin Thursday Afternoon 1
Isabelle Poulin Thursday Afternoon 1
I want to create a nested IF statement which looks at column D and if the
instructors name is there, then it looks at Column E and looks for €śMonday€ť,
and if that is there then it looks in Column F for €śMorning€ť and if that is
there, then counts the number of €ś1s€ť in column H. I tried the following
and it doesnt work; it returns a blank:
=IF(evalsecondlang!D:D<"Catherine
Rousseau","",IF(evalsecondlang!E:E<"Monday","",IF (evalsecondlang!F:F="Morning",COUNTIF(evalsecondla ng!$H:$H,1)," ")))
This would indicate that the values I am looking for are not there, in the
sequence I want. But when I manually check the sheet, all the criteria is
there.
Can anyone please help me figure out what I am doing wrong?
Any and all help is greatly appreciated.
--
LPS
|