Count If

[Ben]

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

 

[Teethless mama]

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

 

[Ben]

Thanks for that...it works.

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