You're welcome, Andy.

Try a fresh post if nobody drops by here
for the single cell formula that you seek.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"andy62" wrote:
Thanks, Max, I may get some use from your formula for another statistic I
have to compile. And I learned something about how to use MATCH and ISNUMBER
in a SUMPRODUCT function. But since my count is of the role the people are
in rather than the people themselves, I would need to count all instances.