Conditional count in a group

[chadb]

I have a table with [id], [manager_id], [employee_id], [employee_score]

I created a report that is grouped by manager. In the manager footer part of the report I have:

=count(*)

This counts the total number of employees for that manager. Now I want to add fields that count the number of employees, for each manager, whose score is less than 70 and those that are between 70 and 90.

Thanks for your help.

 

[chadb]

I think I got one of them figured.

=Sum(iif(employee_score<70,1,0)

but how do i count the number of employees whose score is between 70 and 90 ?