LinkBack URL
About LinkBacks
I am looking for a formula that finds the average female age. My spreadsheet looks a little like this:
A B
Gender Age
M 22
F 46
M 31
M 62
F 25
F 36
F 25
F 57
I am looking for a formula that finds the average female age. My spreadsheet looks a little like this:
A B
Gender Age
M 22
F 46
M 31
M 62
F 25
F 36
F 25
F 57
Try:
=AVERAGEIF(A2:A9,"F",B2:B9)
Thank you Colin! Yes, it did help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks