I have names "McCreight, Doug" in one column and their single letter job code
"M" in next column over. How do I calculate
1. how many rows have a name and a job code?
2. how many rows have entry "vacant" and a job code

Thanks