View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CNeils CNeils is offline
external usenet poster
 
Posts: 1
Default simple average question

I have two columns of data. One column has the gender and the column
alongside has the age of these people. The columns are mixed with males and
female. How do I determine the average age of just the men and just the women?

example:

M 66
F 48
M 20
M 46
F 17

I add to this column week by week so it's not like I can just add everything
up at the end tally the data. Is there a function that I can insert into
another cell that I can label "average age of men" and pull the average age
from the column of information just for the average age of men?