Create a division formula.

a. Click the Bookings sheet tab and select cell F5. Average revenue per passenger can be determined by dividing the fee by the number of passengers.

b. Build the division formula.

c. Copy the formula in cell F5 to cells F6:F19.

= (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