Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of vehicles
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
Looking for form to track mileage of trucking company vehicles. | Excel Discussion (Misc queries) | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |