Watch Arrows Arrows (A Evaluate Formula window B calculate options Hourly Rate C
ID: 639248 • Letter: W
Question
Watch Arrows Arrows (A Evaluate Formula window B calculate options Hourly Rate Chart RSR Computer Services Labor Cost Report In-Home Computer Service Billings 15.00 echnician 3 Date work order Number S 18. Technician Hourly wo Labor Code Rate Cost Labor Cost Statistics 10/1/2015 H-90010 10/2/2015 90011 10/5/2015 H-90012 70.31 By Technician Code Billed Labor 12.50 18. 10/8/2015 12.50 0/8/2015 IH-30014 10/9/2015 IH-90015 Technician 3 290.625 90016 Technician 3 calls over thours 4 10/12/2015 IH-90017 10/13/2015 10/19/2015 12.50 51.55 10/22/2015 sl 10/23/2015 Technician 1 12.50 18,75 10/29/2015 IH-90024 10/10/2015 IH-90025 5.50 2 TOTAL LABOR cost 775.00 6 Using The ranges named Techcode, Laborcost,andHours, Create a SuMIFs formula in cell using The ranges named Techcodeand uborcost, create AVERAGEr formulas in the cells indicated belown Average the labor cost for calls made by technician a add the labor cost forralis made bytechnican3formeria in which the hours logged were greater than three Average the labor cos for calls made by technican 2 Average the labor cont for calls made by technicianExplanation / Answer
=COUNTIF(C1:C15,">3")
=AVERAGE(A2:C2)
a2 b2 c2 contains avergae of individual rows
please make question proper visible
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.