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

How to Calculate Average Sales Revenue in Excel

03 Jul 2021

Based on the data provided:

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.