| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count If
I have two columns of information...how do I count the occurences of one
column according to the criteria of another? The bus code in column B relates to all out bus runs while the information in column A relates to the area our clients live in. I want to count how many times bus code IWCT CAR & Postcode 1, 2, 3, 4 or 5 occurs and so on for all the bus codes. eg: A B Postcode Bus_Code 5 IWCT CAR 1 IWCT CAR 3 IWCT CAR 2 3 IW SHUTTLE 3 IWCT CAR 2 3 IWCT CAR |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
