median calculation
 

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?

median calculation
 

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.
--
Gary''s Student - gsnu200756


"Pammy" wrote:

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?

median calculation
 

Use the MEDIAN function, as in:

=MEDIAN(A1:A6)

On Nov 16, 1:25 pm, Pammy wrote:
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?