Formulas in Rutba Office Worksheets: SUM, AVERAGE, IF and lookups

How to write formulas in Rutba Office Worksheets. This episode adds up a row with plus signs, then with SUM and a range dragged across the cells, and fills the formula down with Control and D. It puts totals in with AutoSum, works out an average week, and marks the good weeks with IF. On an order sheet, XLOOKUP and VLOOKUP bring each product's name and price across from another sheet, Error Checking explains a lookup that found nothing, and IFERROR puts something tidy in its place. The shop and its figures are made up. Download Rutba Office: https://office.rutba.io/download 0:00 An empty column 0:58 Totals at the foot 1:21 An average 2:09 An order