Average age by gender

wlbamc

New Member
Joined
Apr 19, 2016
Messages
42
I am sure there is a simple answer to this question. I need to find the average age of people by their gender. I have used this formula and each time just get #NUM !
Code:
=AVERAGEIF(B2:B696,"F",C2:C696)
Any help gratefully received
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,509
Office Version
365
Platform
Windows
Does #NUM! appear anywhere in C:C696?
 
Last edited:

wlbamc

New Member
Joined
Apr 19, 2016
Messages
42
Thank you so much, I knew it would be something stupid. Yes one of the lines had ~NUM!, corrected it and it is all working. Apologies for bothering people
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,509
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Forum statistics

Threads
1,085,033
Messages
5,381,309
Members
401,733
Latest member
Kabasa007

Some videos you may like

This Week's Hot Topics

Top