Use the SUBTOTAL function to complete the following: In cell H7, insert a formula that counts the number of cells in the Category field that are not empty.
In cell H8, insert a formula that sums the cells in the Units field.
In cell H9, insert a formula that sums the cells in the Subtotal field.
In cell H10, insert a formula that averages the cells in the Retail_Price field.
_PriceStaffStaff_CategoryHotel_Gues tTrans_Type
Receptionist Card
Transaction count
Units sold
Subtotal sum
Retail average
_PriceStaffStaff_CategoryHotel_Gues tTrans_TypeSubtotal
5/1/20181Sph - Hair WrapClothing17.95KendraMassage TherapistYescash$ 17.95
5/1/20182Sandalwood Massage OilMassage Oil19.95$ 39.90
5/1/20182Vanilla Bean Massage OilMassage Oil19.95KellyReceptionistNocheck$ 39.90
5/1/20182Water - rejuvenating, flavored, 12 oz bottleFood4.19PatMassage TherapistNocard$ 8.38
5/1/20182Geranium Rose Bath CrystalsSkincare6.99KendraMassage Therapist