As long as your data is in database format with a name against every ticket
number, then just throw a Pivot table at your data and just have it count
the rcords.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Bob" wrote in message
oups.com...
I have to show how many tickets are disbursed to different people.
Let's say Bob gets tickets 100 to 105. The SUM formula subtracting 100
from 105 is 5 when actually Bob gets 6 tickets. Do i have to add a
hidden column with a value of 1 to insert into the formula? Thanks