Happy Wednesday!
My range is A2:C241
In A2:A241 there are categories Australia, Europe, Japan, South Africa, South Korea, Taiwan, Leadership, Administration
In B2:B241 there are 30 different city names for each of the categories in column A
In C2:C241 there are numbers
I would like to count all the numbers in column C that correspond to each category in column A
I would like to count all the numbers in column C for each city represented
I would like to pull the average total number for each city in Column B and then rank all the cities by their total number, then display in a bar graph
I would also like to pull the average number for each category in column A among all cities and also represent in a bar graph
Would anyone be willing to work with me on this? Thank you!
My range is A2:C241
In A2:A241 there are categories Australia, Europe, Japan, South Africa, South Korea, Taiwan, Leadership, Administration
In B2:B241 there are 30 different city names for each of the categories in column A
In C2:C241 there are numbers
I would like to count all the numbers in column C that correspond to each category in column A
I would like to count all the numbers in column C for each city represented
I would like to pull the average total number for each city in Column B and then rank all the cities by their total number, then display in a bar graph
I would also like to pull the average number for each category in column A among all cities and also represent in a bar graph
Would anyone be willing to work with me on this? Thank you!