Please check one thing in the section [b]Calculate Median Excluding Zero In A Range[/b]
Below there in the first line the word [b]excluding[/b] is to be replaced by [b]including[/b]
Sometimes we may need to calculate the median in a range data which may better reflect the median level of the data. Now I am talking about how to calculate the median in a range in Excel.
There is a formula can help you quickly median the range.
Select a blank cell and type this formula =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 data range 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 formula =MEDIAN(A1:C3,E1:G3, A5:D8)).
Sometimes, if the data is zero, you do not want to calculate the median excluding zero, in this case, you need to use the below formula.
Select a blank 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 meantime, and then you can get the median excluding zero in the cell.
Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
300 New Features for Excel, Make Excel Much Easy and Powerful: