I am using MS Excell 2003. To make it more clearer this is a Worksheet called
Summary that will determine the number of vehicles assigned or used by each
Department. What formula or function do I need to determine the type of
vehicle for each department on the worksheet below using MS Excell 2003.

A B C D E
etc....
(1) Department
(2)Type IT Maintenance Purchasing Planning
(3)Pickup
(4)Sedan
(5)Truck
(6)Van
(7)SUV

"Kula" wrote:

This is a sample worksheet named Vehicle Data to work from.

ID YEAR MAKE TYPE ODOMETER DEPARTMENT
EB122 2003 Nissan Van 24575 Academic
EM911 2004 Toyota Truck 98702 Academic
CW001 1995 Ford SUV 32765 Administration
CY723 1995 Ford Pickup 73419 Administration
CD234 1997 Mistubish Hilux 32564 Medical
FD321 1993 Hino Sedan 94321 Planning
CN210 1991 Toyota Van 138456 IT
DT592 2002 Ford Sedan 37780 Maintenance

I want to make another worksheet to be called Summary to determine the
number of vehicles used by each department. What function am I to use?