Hi i'm having probelms getting around this.

Need to match 3 columns between two sheets in the same workbook to count
specific occurences. below is how i've set it up.

in sheet 1, i've got the following data for eg.....
SHEET 1
Company Country Industry Tier
1 air asai malaysia airline 1
2 china air china airline 1
3 sia singapore airline 3
4 hanjin malaysia shipping 1
5 wanhai china shipping 3
6 cosco singapore shipping 3
7 vitol malaysia trading 1
8 trafigura china trading 3
9 sinopec singapore trading 3
10 origin malaysia producer 1
11 sonangol china producer 2
12 petrochina singapore producer 2


i've got 3 other sheets where i've filtered the companies accoding to the
tiers. so 3 sheets for 3 tiers. so for example in sheet 2 i've got all the
tier 1 companies, sheet 3 tier 2, and sheet 4, tier 3. (Sheet 2 below)

what i need to do is to count the number of names in each country for the
various industry types by referencing or matching the names to the
corresponding data in sheet 1. how do i do this to return the appropriate
values in the (count) brackets below? you will have my eternal gratitude if
you could solve this for me!

thanks ahead....


SHEET 2

airline (count) (count) (count)
shipping (count) (count) (count)
trading (count) (count) (count)
producer (count) (count) (count)

malaysia china singapore


1 air asai
2 china air
3
4 hanjin
5
6
7 vitol
8
9
10 origin
11
12