How do I calculate a median using dollar values?

English
#1

I have 35 values and would like to calculate the median of those values.

#2 
=MEDIAN(A1:A35)

Or if you actually meant average instead (people sometimes confuse these) then

=AVERAGE(A1:A35)
#3

Note: the arguments must be numeric values. You can not make any calcuations with the $1 like STRINGS.

#4

Yeah right, s/he didn’t say what “dollar values” actually are, I assumed amounts of currency formatted numeric values, not text content.

In that case see this FAQ.

#5

Thank you. I was able to calculate the median. Much appreciated.

#6

Glad to help. Then please mark the answer as correct by clicking the check mark icon. Thanks.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.