median calculation

[Guest]

I have a column that has entries that start with Fiscal year 07 numbers which
are from 07/01/07 to 06/30/08, and a cell that gives me the average so far
this year. Is there a way to take this col Fiscal year and get a median for
FY07-08?

 

[Guest]

say your data is in A1 thru A366:

=MEDIAN(A1:A366) should be good, because MEDIAN will ignore the blanks
associated with data not yet available.

 

[Michael Malinsky]

Use the MEDIAN function, as in:

=MEDIAN(A1:A6)