hello again roger,

Your solution does get me the desired result but it is not dynamic;
everytime I change departments, i need to redo a count for all
positions. (since what you suggested was not part of the PT and the
number of rows displayed changes).

I thought there was a way to get just the number of employees who
followed a training session - easily. I guess not...

I will continue looking for a solution when I can... in the meanwhile I
suppose this will have to do.

I get the impression the data would have to be reformated a little to
prevent the sum of all sessions followed...

thank you for your help

louis


--
louisp
------------------------------------------------------------------------
louisp's Profile: http://www.excelforum.com/member.php...o&userid=25880
View this thread: http://www.excelforum.com/showthread...hreadid=511160