LinkBack URL
About LinkBacks
i need to get the median of a range of numbers that are not in a consecutive range. there are too many arguments though and the program cuts me off. any suggestions?
i need to get the median of a range of numbers that are not in a consecutive range. there are too many arguments though and the program cuts me off. any suggestions?
Hello there,
It’s not exactly clear what you are trying to achieve from the information given. But if you can provide a small zipped sample of your data, then hopefully a solution can be found.
To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this zipped file to your post.
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
thanks for your help. here is a data example with a setup similar to my workfile. in this example i want to find the median of all stores that are designated as Urban (which should be 3).
In my actual workfile, i try using =median(c1,c3,c6,c7,...) but have too many arguments, as its a much larger data set.
am wondering if there is a way to find median similar to the way the SUMIF function finds the sum of only certain numbers...
thanks in advance
Try this formula
=MEDIAN(IF(C4:C14="urban",D4:D14))
confirmed with CTRL+SHIFT+ENTER (so that curly braces like { and } appear around the formula in the formula bar)
hey thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks