median calculation

P

Pammy

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

Gary''s Student

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.
 
Top