median

[jlogan987]

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?

[oldchippy]

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.

[jlogan987]

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

[daddylonglegs]

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)

[jlogan987]

hey thanks