Maths in Excel , sorry

Im quite stuck tbh. I could do thats maths on paper but using

excel is :eek:

1st is the mean

ive got =sum(a1:A11)/11

Theres 11 cells data so am i correct by putting 11 should i use some formula for counting cells that contain data?

2nd Median

if i remember the middle point so 1-2-3-4-5
3 being the median?

ive a set 11 numbers to how do i say, excel get me the middle numbers in this coloum data.

If you understand me great, if not sorry :(

Si

[Edited by super_si - 2/18/2003 4:56:00 PM]

1. =AVERAGE(A1:A11) this works even if some cells are empty.

2. =MEDIAN(A1:A5)

If you are not sure how to use these, RTFM.

Cheers

Ian

thanks :D