how to count the number of employees have Delta 320

Louis.Smith · 08/30/23

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 · 08/30/23

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

Louis.Smith · 08/30/23

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

unique employee numbers.

Paul Newcome · 08/30/23

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.

how to count the number of employees have Delta 320

Answers

Help Article Resources

Categories