Answer:
=(A4+B4+C4+D4+E4)/5
Explanation:
If we want to have the average of the passengers, first we must sum all the revenue and then divide it with passenger quantity.
In this particular example, I made the formula with 5 passengers, I sum the 5 revenues and then I divide with 5 passengers if there are more passengers we must sum all of them, and divided all of them, for example:
=(A4+B4+C4+D4+E4+F4)/6
