coounting references between sheets
 

hi, dnot' really know how to get this done.

Same workbook.

Sheet 1
Column 1 = Names
Column 2 = Types of industry
Column 3 = Rating

Sheet 2
Column 1 = Names filtered by rating in Sheet 1


now how do i do a count of the number of names in col 1 of sheet 2 according
to the various types on industries in col 2 of sheet 1?

so i will list the various industries in sheet 2. how do i put a count in
the cell next to each category of the names in col 1 of sheet 2?

hope i'm making sense here and you could help. thanks!

coounting references between sheets
 

hi
not sure if i understand completely but if each name is associated with an
industry type, you need to count industry types which should give you the
count of the associated names.

=countif(Sheet1!B:B,"IndustryType")

or did i get confused?

Regards
FSt1

"Dez" wrote:

hi, dnot' really know how to get this done.

Same workbook.

Sheet 1
Column 1 = Names
Column 2 = Types of industry
Column 3 = Rating

Sheet 2
Column 1 = Names filtered by rating in Sheet 1


now how do i do a count of the number of names in col 1 of sheet 2 according
to the various types on industries in col 2 of sheet 1?

so i will list the various industries in sheet 2. how do i put a count in
the cell next to each category of the names in col 1 of sheet 2?

hope i'm making sense here and you could help. thanks!

coounting references between sheets
 

Hi hope this clarifies.

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


now ive 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.m sheet 3 tier 2 and sheet 4, tier 3.

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 me eternal gratitude if
you could solve this for me!

cheers 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


"FSt1" wrote:

hi
not sure if i understand completely but if each name is associated with an
industry type, you need to count industry types which should give you the
count of the associated names.

=countif(Sheet1!B:B,"IndustryType")

or did i get confused?

Regards
FSt1

"Dez" wrote:

hi, dnot' really know how to get this done.

Same workbook.

Sheet 1
Column 1 = Names
Column 2 = Types of industry
Column 3 = Rating

Sheet 2
Column 1 = Names filtered by rating in Sheet 1


now how do i do a count of the number of names in col 1 of sheet 2 according
to the various types on industries in col 2 of sheet 1?

so i will list the various industries in sheet 2. how do i put a count in
the cell next to each category of the names in col 1 of sheet 2?

hope i'm making sense here and you could help. thanks!