Hi,

NBVC has provided you with an excellent formula, which would work for hundreds of names ... the formula has to be adjusted accordingly ...

However, if you want a summary table, I would recommend a simple pivot table ...

HTH
Carim