Maybe something like these would suffice:
1. =SUMPRODUCT((OR(A2:A10<{"","vacant"}))*(B2:B10<" "))
2. =SUMPRODUCT((A2:A10="vacant")*(B2:B10<""))
assuming names/"vacant" in col A, job codes in col B
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dougmcr8" wrote:
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