Finding the mean/median of listed data

Hi there,

I am trying to get the mean and/or median of ages of a specific set but the data is organised in lists. i.e. the population that is aged 0 is presented by the number 10626.8 rather than the number 0 appearing 10626.8 times.

There is data for every age up until 85 where it is grouped into 85+.

For some reason I cannot paste a screenshot in here so I'm hoping that this is enough information!

Thanks so much for your help, really appreciate it

Capture.PNG

Not sure if this picture grab will work...

Guessing ... you probably need a conditional median for example to exclude zeros within the data
Try something along these lines:
Put in say B2: =MEDIAN(IF(A2:A5>0,A2:A5))
then press CTRL+SHIFT+ENTER to array enter the formula

Well no because people aged 0 are just under 1, they are still members of the population. There is no data that I don't want to include

Still guessing ... one variation of the earlier that could suit what you have/are trying to do

Assume you have the text names of the age buckets in A2:A100 eg: Age 0, Age 1-15, etc
and in B2:B100 are the corresponding data values (numbers)

Place in say C2: =MEDIAN(IF($A$2:$A$100="Age 0",$B$2:$B$100))
then press CTRL+SHIFT+ENTER to array enter the formula [instead of just pressing ENTER]