RIDGEWAY ARCHITECTS - OCTOBER BILLING WORKBOOK (NOTES ON WHAT IS BROKEN) (Made-up firm and numbers for a Stepthrough practice lesson.) The workbook has two sheets. SHEET "Rates" (A1:B5) A1: Project Code B1: Hourly Rate A2: RW-101 B2: 165 A3: RW-102 B3: 140 A4: RW-103 B4: 185 A5: RW-104 B5: 150 SHEET "Timesheet" (A1:E6) A1: Staff B1: Project Code C1: Hours D1: Rate E1: Amount A2: Dana B2: RW-101 C2: 6.5 D2: 165 E2: 1072.5 A3: Marcus B3: "RW-102 " C3: 8 D3: #N/A E3: #N/A A4: Elena B4: RW-103 C4: "7.5 hrs" D4: 185 E4: #VALUE! A5: Dana B5: RW-105 C5: 4 D5: #N/A E5: #N/A A6: Marcus B6: RW-104 C6: 5 D6: 150 E6: 750 Notes on the cells in quotes: - B3 really contains RW-102 followed by one space (it was pasted from an email). - C4 really contains the text 7.5 hrs, typed by hand. - B5 is RW-105. There is no RW-105 on the Rates sheet. The project was opened last week. The formulas: - D2 (copied down to D6): =VLOOKUP(B2,Rates!A:B,2,FALSE) - E2 (copied down to E6): =C2*D2 Two more cells at the bottom of the Timesheet sheet: - E8, "Total billed": =SUM(E2:E6) shows #N/A - E9, "Average rate per hour": =E8/SUM(C2:C6) shows #N/A - E10, "Share billed to RW-106": =SUMIF(B2:B6,"RW-106",E2:E6)/SUMIF(B2:B6,"RW-106",C2:C6) shows #DIV/0! And one on a third sheet, "Summary": - B2, "October total": =Timesheet!#REF! shows #REF! (It worked last month. Yesterday someone deleted the old column F on the Timesheet sheet, which held last month's total.) What I need: every invoice for October goes out Friday. I need each error explained in plain words, fixed the right way, and the real total.