Calculate average age (years)

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

FAQ

Mark Forums Read

Thread Tools

Display Modes

08-12-2017, 09:05 AM

Pecoflyer

Windows 7 64bit Calculate average age (years)

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

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

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Tags

average, excel 2007

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 12:09 AM.