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?
|