In range B5:B7, using the appropriate Subtotal functions, create three subtotal formulas. In B5, calculate the total Miles driven, in B6 calculate the average rental Price, and in B7 calculate the total number of rentals (CarID) for the filtered data set. Use the named ranges when creating the formulas. Format B6 with Accounting umber format
Solved by I. H. in 13 mins