7. Using the ranges named TechCode, Labor (Cost, a ours, create a SUMIFS formula

Question

7. Using the ranges named TechCode, Labor (Cost, a ours, create a SUMIFS formula in cell J14 to add the labor cost for calls made by technician 3 criteria 1) in which the hours logged were greater than three (criteria 2) 8. Using the named ranges Tech e and LaborCost, create RAGEIF formula in the cells indicated below: J18: Average the labor cost for calls made by technician 1 J19: Average the labor cost for calls made by technician 2. J20: Average the labor cost for calls made by technician 3. 9. Apply comma formatting to the following cells: J9:J11 J14 J18:J20

Explanation / Answer

=COUNTIF(C1:C15,">3")

=AVERAGE(A2:C2)

a2 b2 c2 contains avergae of individual rows

To format numbers in Excel 2010 with the Comma style, follow these steps:

Select the cells containing the numbers you want to format.

On the Home tab, click the Number dialog box launcher.

The Format Cells dialog box appears, with the Number tab on top.

In the Category list, select Number.

Select the Use 1000 Separator (,) check box.

Click OK.

Related Questions

Navigate

• Browse (All)
• Browse 7
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.