How to Calculate Average Sales Revenue in Excel

What is the formula to calculate average sales revenue in Excel?

Based on the data provided:

  • January: $5,000
  • February: $6,000
  • March: $7,000
  • April: $8,000
  • May: $9,000

Formula to Calculate Average Sales Revenue:

To calculate the average sales revenue in Excel, you can use the following formula:

=AVERAGE(B2:B6)

The formula =AVERAGE(B2:B6) will calculate the average of the sales revenue data provided in cells B2 to B6.

By entering this formula in a cell in Excel, you will get the average sales revenue for the months of January to May.

Make sure to replace the cell references (B2:B6) with the actual range where your sales revenue data is located in your Excel worksheet.

← Creating a form for data entry which table to use How to change and create consistent formatting in grouped worksheets →

More Posts: