For the homework, I had to make a list of ny times best seller list, with the prices, number of weeks on the list etc. Then, I was asked to do list these:


In the same row in Column D that "Sum of All Prices" appears in Column A, write "Title of Highest Priced Book". Below that cell, write, "Title of Lowest Priced Book." Below that cell, write, "Title of Longest Best Selling Book." In the corresponding cells in Column E, write functions that will get the correct titles to appear.

I'm not even sure what formulas to use for this, can someone help me out?