how to count the number of employees have Delta 320

Louis.Smith

I am wanting to count the number employees have delta in fleet and 320 in client. There are duplicate employee numbers in the emp_nbr column.

Paul Newcome

Are you only wanting a count of unique employee numbers meeting those criteria or all of them including duplicates?

Louis.Smith

https://community.smartsheet.com/discussion/comment/393313#Comment_393313

unique employee numbers.

Paul Newcome

In that case you would use

=COUNT(DISTINCT(COLLECT(...............)))

You would use the employee number column as your first range in the COLLECT then follow it up with range, criteria, range, criteria to include the ranges and criteria to filter by.