Find multiple averages from one column of data using one simple formula?

[Morgan44]

Hi there!

I am working on Excel for an assignment (we are allowed to use any resources needed) and the assignment is to find 19 stock return price averages for 19 companies. The condition is that I can't input multiple formulas, I can only input one into the first company's average price and then drag it down for the rest. All of the return prices are in one column. How can I find 18 averages from one column in a way where Excel knows to average all of Company A's together, Company B's, and so on and so forth? I've tried If statements, AverageIf, and have fiddled with arrays and Index, but nothing is seems draggable. Any tips?

Thanks! Happy to give more information as needed.

[JBeaucaire]

AVERAGEIFS is the function you want.

=AVERAGEIFS(ValuesToAverage, Range1, Criteria1, Range2, Criteria2)

=AVERAGEIFS($C$2:$C$62, $B$2:$B$62, E4, $C$2:$C$62, "<>""")

[Morgan44]

Thank you so much! That makes more sense, thank you!!