Expression logic help please

[#1]

I have a excel file as below

Here the logic I have to get in a single expression is ,

1.1.If Room type is WRKST and OFFICE then count only the Employees with the email attached (Don’t count the Empname with blank)

2.If room Type is anything else other than OFFICE and WRKST then count employees with name and the blank fields too.

The issue I am facing is I am counting the Employee name twice.Any help is appreciated.

Thank you.

[sunny_talwar]

Can your provide the data in an excel format with the expected output.

[Peter_Cammaert]

Expression 1:

=count({<[RM RoomType]={'WRKST', 'OFFICE'}, [EM EmployeeName]={"=len(trim([EM EmployeeName]))>0"}>} [RM BuildingCo])

Expression 2:

=count({<[RM RoomType] -= {'WRKST', 'OFFICE'}>} [RM BuildingCo])

[#4]

Logic help Please

Not sure how to attach the file here,so created a new thread ..sorry and above is the link to find the excel ifle.Thank you very much

[Peter_Cammaert]

To attach a file to a post, click "Use Advanced Editor" in the top right, and in the editor select "Attach" on the bottom right.