How to interact with values in a second column based on the categories of a first column?

[RoSothian]

I have two columns, Category of Equipment and Labor Hours. Each individual cell of the CoE column is one of a few different categories. Door, Rack, Kit, Base, Shelf, Accessory, etc. The Labor Hours shows the time taken to install specific products, based mostly on category. What I'm trying to do is take each category (multiple CoE column duplicates), get the Labor Hours values for all of the respective cells, then get the mean, median, mode, range, etc. per the total of each category.

 

[bhos123]

One simple way would be Sort the data by Category of the equipment... and then create the formulas using references. and drag sidewords(not downwords)

 

[RoSothian]

One simple way would be Sort the data by Category of the equipment... and then create the formulas using references. and drag sidewords(not downwords)

Something I just noticed is that there is actually a category and a subcategory. So I have to sort by two columns somehow. If I have one going along the top row and another going along the leftmost column, then it would work with Labor Hours going diagonally from the top-right to the bottom-left, but I don't know how to do that or if it's right.

 

[bhos123]

simply sort by Equipment.. then use the normal formula for each category separately.