Count variables in a single field then Sum results in a query

[GRUNT]

As a beginer,Im trying to COUNT values in a single field where they meet the critria below., Then SUM then altogether.

Coursename,enddate1 and enddate2 are Request.QueryStrings form an .ASP web page which gnerates the query

The field is wish to SUM is "SERVICELEVEL"
I wish to COUNT the following
addressbook.ServiceLevel='Officer' +
addressbook.ServiceLevel='Senior Ranks' +
addressbook.ServiceLevel='Junior Ranks' = x

The critiria

SELECT *
FROM Courselist INNER JOIN (addressbook INNER JOIN Applications ON addressbook.PersonID = Applications.PersonID) ON Courselist.CourseID = Applications.CourseID
WHERE addressbook.Service='RN' AND  AND(Applications.StatusCode='Passed' OR Applications.StatusCode='Failed')  AND courselist.CourseTitle=coursename AND courselist.EndDate BETWEEN enddate1 AND enddate2

Im a bit stummped

[NeoPa]

Even after tidying up your SQL I still find no reference in there to [ServiceLevel].

SELECT *
 
FROM Courselist INNER JOIN 
    (addressbook INNER JOIN 
     Applications
  ON addressbook.PersonID = Applications.PersonID)
  ON Courselist.CourseID = Applications.CourseID
 
WHERE addressbook.Service='RN'
  AND (Applications.StatusCode='Passed'
   OR Applications.StatusCode='Failed')
  AND courselist.CourseTitle=coursename
  AND courselist.EndDate BETWEEN enddate1 AND enddate2

This will work much better if you can post the meta-data (info about the layout / structure) of the table in the same way as I use in my example. Click on the Reply button and you will have access to all the codes I've used. PK & FK stand for Primary Key & Foreign Key respectively.
Table Name=[tblStudent]

Field; Type; IndexInfo
StudentID; AutoNumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time