Fresh Excel Tips

In this example the average and median sales for a month have to be determined. We will use the data shown in image below and calculate the average sales in cell E2. To calculate the median of the sales, use the MEDIAN function. The median is a value in the middle of a set of values; that is, half the values are above the median and half the values are below. Here is the syntax that is used for the MEDIAN Function:

MEDIAN(number1, number2, …)
number1, number2,… : From 1 to 30 numbers for which you want to find the median.

To calculate the median sales:

1. In cells A2:A13 type the month.
2. In cells B2:B13 type the monthly sales.
3. Select cells E1 and type the following formula: =MEDIAN(B2:B13).
4. Press Enter.

You can find the average, as shown in cell E2, by using the formula =AVERAGE(B2:B13).

This tip is compatible with Excel 97, 2000, 2003 and 2007.

1. How to Calculate the Average Speed Using Excel
2. Use the MIN function to find the employee with the lowest sales
3. How to calculate the average output using the AVERAGE function
4. How to Use the SUBTOTAL function to perform several operations
5. Use the AND function to show sales for a specific period of time