• 469K Members
• 4,499 Online
• 568K Conversations
SOLVED

New Contributor

# Median

Pls help. I have a column of numbers that range 2-78 (2, 13, 62, 75, 15, 80). What is the formula to get the median of this column while excluding any numbers over 60? I’m going to keep adding to this column so I need the median formula to only include numbers 60 and below. Thank you.
3 Replies
Solution

# Re: Median

Hi,

You may use array formula (Ctrl+Shift+Enter to enter it)

`=MEDIAN(IF(A2:A78<=60,A2:A78,""))`

or regular one

`=AGGREGATE(16,6,A2:A78/(A2:A78<=60),0.5)`

# Re: Median

Thank you so much!!!

# Re: Median

You are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies