Hi all,
I want to find the median of a set of data but exclude any "0"s from the median calc, like I did with the "averageif" formula. Any ideas?
Thanks!
ex set of data
200
232
0
150
10
411
0
Hi all,
I want to find the median of a set of data but exclude any "0"s from the median calc, like I did with the "averageif" formula. Any ideas?
Thanks!
ex set of data
200
232
0
150
10
411
0
Assuming there are no negative numbers...
Array entered**:
=MEDIAN(IF(A2:A8>0,A2:A8))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks