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

Count If
 

=SUMPRODUCT((Postcode={1,2,3,4,5})*(Bus_Code="IWCT CAR"))


"Ben" wrote:

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

Count If
 

Thanks for that...it works.

"Teethless mama" wrote:

=SUMPRODUCT((Postcode={1,2,3,4,5})*(Bus_Code="IWCT CAR"))


"Ben" wrote:

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