Sheets AcademySheets Academy
Premium
Task #28

Managers by city

Build a report: how much revenue each manager brought in in each city. In the table G2:I5, managers are in rows and cities are in columns.

  1. Write a single formula in G2 so that it can be dragged both right and down.
  2. Drag it across the whole table G2:I5.
Task #28
Managers by city

Build a report: how much revenue each manager brought in in each city. In the table G2:I5, managers are in rows and cities are in columns.

  1. Write a single formula in G2 so that it can be dragged both right and down.
  2. Drag it across the whole table G2:I5.