"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
---