This assumes your data validation cell in H3, your NAMED list is k1:k??
Right click sheet tabview codeinsert this. Now when the validation is
selected the count for each choice will increase in col L.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$H$3" Then Exit Sub
mrow = Range("mlist").Find(What:=Target, after:=Cells(1, "k"), _
LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False).Row
Cells(mrow, "L") = Cells(mrow, "L") + 1
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ihrod9" wrote in message
...
I am creating a basic diary and have a drop-down box with all of the
possible
people who could be booked into a particular day. I select the name from
the
drop-down box but is there any way of totalling how many times that user
has
been selected from the drop-down box?