# How to calculate median in a range in Excel?

## How to calculate median in a range in Excel?

sometimes we may need to calculate the medial in a range data which may better reflect the median level of the data. now I am talking about how to calculate the medial in a range in Excel .
Calculate median in a range
Calculate median excluding zero in a range
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier…

80%

• Reuse Anything : Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
• More than 20 text features : Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
• blend Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
• split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
• paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
• superintendent filter : Create advanced filter schemes and apply to any sheets; sort by week, day, frequency and more; trickle by bold, formulas, comment…
• More than 300 powerful features ;Works with Office
2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

#### Calculate median in a range

There is a formula can help you promptly median the stove .
Select a space cell and type this recipe =MEDIAN ( A1 : C6 ) ( A1 : C6 indicates the range you want to calculate median from ), press Enter key, and then you can get the median in the cell .

Tip : If the datum compass is not continuous, you can use this formula =MEDIAN ( A1 : C3, E1 : G3 ) ( A1 : C3 and E1 : G3 are the ranges you want to calculate the median from, and the comma indicates and. If you have three discontinuous ranges, you can use rule =MEDIAN ( A1 : C3, E1 : G3, A5 : D8 ) ) .

#### Calculate median excluding zero in a range

sometimes, if the data is zero, you do not want to calculate the median exclude zero, in this case, you need to use the under formula .
Select a lacuna cell and type this formula =MEDIAN ( IF ( A1 : C6 > 0, A1 : C6 ) ) ( A1 : C6 indicates the range you want to calculate median from ), press Ctrl + Shift +Enter keys in a interim, and then you can get the median bar zero in the cell .

### The Best Office Productivity Tools

#### Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

• Reuse : Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List

and send emails…

• Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); spread to Filtered Range…
• Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns… Prevent Duplicate Cells; Compare Ranges…
• choice Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select…
• claim Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more…
• Extract Text, Add Text, Remove by Position, Remove space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments…
• Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; particular Filter by bold, italic…
• Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF…
• More than 300 brawny features. Supports Office/Excel
2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features
30-day free trial. 60-day money back guarantee.

#### Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.