Help with multi-function (SUM, COUNTIF, AVG) coding and graph

[brooksc29]

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!

 

[mrshl9898]

Highlight the data and Insert>Pivot Table (Do a separate one for all your questions)

select a location for it

Then organise the fields by dragging the headers into one of the four boxes down the bottom

To change SUM to AVERAE for question 3, select value field settings

Average then OK

To rank them select the drop down on Row Labels and More Sort Options, make your selection and OK.

Insert Pivot Chart, select chart type and ok.