How to calculate the median in visible cells only in Excel？
Sometimes, we use the median value to instead of average. Usually, you can use =Median() to calculate a list of data. But if some data of the list has been hidden or filtered, how can you get the right median value in the visible cells only? In this article, I will introduce a formula to calculate the median only in the visible cells in Excel.
Sum/Average/Count visible cells/Filtered only in Excel
|Only calculate the visible cells and skip the hidden cells. Click for 60 days free trial!|
|Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days.|
Here is a simple formula can do you a favor on calculating median value.
Select a cell which you will place the median value, type this formula =AGGREGATE(12,1,A2:A17) into it, then press Enter key.
If you want to average or sum data in visible cells only, you can try the AVERAGEVISIBLE and SUMVISIBLE functions in Kutools for Excel.
|Kutools for Excel, with more than 200 handy functions, makes your jobs easier.|
After installing Kutools for Excel, please do as below:（Free Download Kutools for Excel Now!)
Also, you can directly use formula =SUMVISIBLE()/em> or AVERAGEVISIBLE()/em> to calculate if you have installed Kutools for Excel.
Tabbed browsing & editing multiple Excel workbooks/Word documents as Firefox, Chrome, Internet Explore 10!
You may be familiar to view multiple webpages in Firefox/Chrome/IE, and switch between them by clicking corresponding tabs easily. Here, Office Tab supports similar processing, which allow you to browse multiple Excel workbooks or Word documents in one Excel window or Word window, and easily switch between them by clicking their tabs. Click for free 45-day trial of Office Tab!