Excel tutorial

How to calculate medians for multiple variables in Excel

One of the shortcomings of Microsoft Excel is that you cannot easily obtain the median for several different variables. Mystery solved. At first glance, this may look complicated. But it's really not too difficult to recreate.

1. Simple median

If you want a median for all the numbers in a column (for example, numbers listed cells B2 through B500), simply type in this formula

2. Multiple medians

Here's how to calculate the median for a series of categories in one spreadsheet (for example a series of home sales where the town is listed in column A and the sales price for each home is in column B). For our example, we'll assume the number of rows does not exceed 10,000.

Step 1

Step 2

Step 3

Step 4

See more Excel tips