= IF[Instructor 1 Last Name]@row = "" - AND [Instructor Status]@row = "U.S. Instructor" - I need it to count as 1. Otherwise, 0.
What I've written above is what I want to do. Below is the formula, which gives me the dreaded #UNPARSEABLE.
=IF(AND([INSTRUCTOR 1 LAST NAME]@row=””, [INSTRUCTOR 1 STATUS]@row=”U.S. Instructor”, 1, 0))
After I can get this straightened out, then it becomes more complicated.
Then I need to check that Instructor 2's LAST NAME does not equal Instructor 1's LAST Name.
Then I need to check that Instructor 3's LAST NAME does not equal Instructor 1 & 2's LAST NAMES
Finally, I'll need to check that Instructor 4's LAST NAME does not equal Instructor 1, 2, & 3's LAST NAMES.
Sometimes we have a group of instructors who go to teach in one location. Sometimes we only have 1 instructor who will teach at least 2 courses. (Even though there are 2 courses taught, we only count it as 1 instructor even though his name will appear twice for this trip.)
I need a count of instructors who go to teach each quarter, and I need to know if they are Nationals or if they are U.S. Instructors.
All names columns are TEXT only. (My brain is slowly frying....) 
Thanks for any help!!
