How to Use the Excel MEDIAN Function

tpernsley@pbp.com'
Tyrone Pernsley
2,164 Comments

In this week’s Excel tip, we cover how to use the Excel MEDIAN function. The MEDIAN function is used the return the median value within the defined range.

For this demonstration, we will use the follow example:

median-image-1

The task assigned for this spreadsheet was to find the median sale amount. To do this, we will use the MEDIAN formula:

=MEDIAN(Number1, [number2]..)

Since the goal is to find the median in a single range, the formula becomes:

=MEDIAN(D2:D21)

median-image-2

And once you enter the formula, you get the return value:

median-image-3

Since there were 20 cells within the range, the formula found the average between two middle values.

We at Learn Excel Now hope you feel comfortable using the MEDIAN function now.

Like Learn Excel Now? Follow us on social media and share our content with your networks! And don’t forget to sign up for the Newsletter

Kevin – Learn Excel Now

Responses

  924. wallpaper wallpaper 4k wallpaper engine wallpaper iphone wallpaper pc wallpaper handy wallpaper aesthetic wallpaper 4k pc wallpaper 1920x1080 wallpaper ipad wallpaper frühling wallpaper abyss wallpaper hd wallpaper 2560x1440 wallpaper 4k iphone wallpaper September 1, 2025

    wallpaper wallpaper 4k wallpaper engine wallpaper iphone wallpaper pc wallpaper handy wallpaper aesthetic wallpaper 4k pc wallpaper 1920×1080 wallpaper ipad wallpaper frühling wallpaper abyss wallpaper hd wallpaper 2560×1440 wallpaper 4k iphone wallp…

    How to Use the Excel MEDIAN Function – Learn Excel Now

  1781. Cleaning services in Edinburgh End of tenancy cleaning Edinburgh Moving out cleaning service Edinburgh Cheap cleaning services Edinburgh Green deep clean Edinburgh Professional cleaner Edinburgh Commercial cleaning company Edinburgh Commercial cleaning se September 23, 2025

    Cleaning services in Edinburgh End of tenancy cleaning Edinburgh Moving out cleaning service Edinburgh Cheap cleaning services Edinburgh Green deep clean Edinburgh Professional cleaner Edinburgh Commercial cleaning company Edinburgh Commercial cleani…

    How to Use the Excel MEDIAN Function – Learn Excel Now

  1921. Make your TRON wallet unforgettable with a free TRON & TRC20 & USDT vanity address generator that creates addresses with lucky endings like "88888." This tool generates TRON and TRC20-compatible addresses that are both functional and distinctive September 26, 2025

    Make your TRON wallet unforgettable with a free TRON & TRC20 & USDT vanity address generator that creates addresses with lucky endings like “88888.” This tool generates TRON and TRC20-compatible addresses that are both functional and distinctive

    How to Use the Excel MEDIAN Function – Learn Excel Now

  2122. https://world-Businesses.com/-----/ September 30, 2025

    https://world-Businesses.com/%D0%BE%D0%BD%D0%BB%D0%B0%D0%B9%D0%BD-%D1%83%D1%81%D0%BB%D1%83%D0%B3%D0%B8-%D1%8E%D1%80%D0%B8%D1%81%D1%82%D0%BE%D0%B2-%D0%B1%D0%B5%D1%81%D0%BF%D0%BB%D0%B0%D1%82%D0%BD%D0%BE-%D0%B2-%D1%81%D1%82%D0%BE/

    How to Use the Excel MEDIAN Function – Learn Excel Now

Comments are closed.

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .