A Pivot Table seems like your best bet. If you want an alternative, try
sumproduct. Here is one example:
=SUMPRODUCT(--(C2:C9="Ford"))

There is a great tutorial on the sumproduct function he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Here are some good tutorials on working with Pivot Tables:
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.contextures.com/xlPivot02.html


Regards,
Ryan--


--
RyGuy


"Max" wrote:

"Number of Vehicles(re-suggest)" wrote:
it doesnt halp........isnt there any other way to solve such problem of inserting appropriate formulas rather than using pivot tables coz it doesnt help

It doesn't help? Don't you get the results that you're looking for? Or, the
pivot approach somehow doesn't appeal to you for some reason?

In your summary sheet,
List* the departments in A2 down, eg: Academic, etc
Then place this in B2: =COUNTIF('Vehicle Data'!F:F,A2)
Copy down. The returns should suffice for your needs.

*the uniques list of departments would be an auto-generated output in the
pivot approach.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---