simple average question

[CNeils]

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?

 

[Jim Thomlinson]

Something like this should do...

=SUMIF(A2:A7, "=M", B2:B7)/COUNTIF(A2:A7, "=M")

 

[Gary''s Student]

Try the array formula:

=AVERAGE(IF(A1:A1000="M",B1:B1000))

entered with CNTRL-SHFT-ENTER rathr than just the ENTER key.