Possibly you can use SUMIF()

e.g. =Sumif($A$1:$A$100,"Johnny B.",$B$1:$B$100)

Where A1:A100 contain the names of the employees and B1:B100 contain
the number of vacation days


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=558889