how to count the number of employees have Delta 320
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.
Answers
-
Are you only wanting a count of unique employee numbers meeting those criteria or all of them including duplicates?
-
unique employee numbers.
-
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.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!