In All Closing worksheet, use AVERAGEIF function to calculate the monthly average stock price for five
firms and NASDAQ, and show your results. After you input all possible month values, use mixed reference
so that you will need to type formula with AVERAGEIF only once to calculate the monthly average price for
all firms. Your results would look like following. (Notes: (1) the order of the month could be either ascending
or descending; (2) You could show your results beginning from any columns or rows, as long as in All Closing
worksheet.)
Solved by S. J. in 14 mins