Calculate average age (years)

		Microsoft Office Forums > Microsoft Excel > Excel
Calculate average age (years)

08-12-2017, 09:11 AM

lyiio

Windows 8

Office 2007

Novice

Join Date: Aug 2017

Posts: 2

Quote:

Originally Posted by Pecoflyer

perhaps something like =sumproduct((datedif(c2:c10,today(),"y"),--(b2:b10="m"))/countif(b2:b10,"m")

for men
replace "m" with "f" for women

Thank you so much for you reply!

I switched the two parts in sumproduct now it works! thank you and hugs!!!!!!!!!

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to calculate average time	aymanharake	Excel	6	02-17-2017 04:22 PM
How to calculate weighted average in table?	alexsimpson	Word Tables	3	12-01-2016 03:19 PM
dynamic ranges to calculate average	teatree	Excel	1	11-11-2016 10:11 AM
Calculate average age	FTL	Excel	1	08-09-2016 06:56 AM
Using Field Codes to Calculate 5 years from a Date	vandy	Word	1	09-23-2009 11:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:03 PM.