Transcript
Instructions
- In your category sheet (genre, actors, or directors), create a column for average ROI.
- Use an array formula to calculate the average ROI for the first item in your category.
- Copy the Average If array formula.
- Change the number format to percent.