in cell J$14,$insert the sumifs function to calculate the total salaries for representatives hired before $1/1/2015.$ Use ranges for the critera ranges and the reference to cell H$9$ that contains Representatives. Enter the date condition directly in the criteria box. Use mixed references to the ranges and cell reference so that you can copy the function in the next step.