Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2016, 06:47 AM
FTL FTL is offline Calculate average age Windows 8 Calculate average age Office 2016
Novice
Calculate average age
 
Join Date: Mar 2016
Posts: 5
FTL is on a distinguished road
Default Calculate average age

Hi,



I have a series of columns dedicated to several names, starting from column J: e.g. from J to P one name, from R to X the second one, from Z to AF the third, and so forth (i divided them with an empty column for better reading).

Each second column of each name is his/her date of birth, and the 3rd column is his/her age (years,months with datedif function) at the beginning of each year (each row on column I is for consecutive years).

Now what i want, if possible, is to calculate the average years and months of ALL names on each year on column D. That is, how to combine each 3rd column on each name to calculate their average on a different year.

e.g. : In 1968 (cell I68), 1st name was 34 years, 6 months old (L68), 2nd name was 37 years, 2 months old (T68); in 1969 (cell I69) they were one year older (lol), and so on, so how can i calculate on each row of column D the average age of all "age" cells on any given year? There are not that many names (between 10 to 40).

Thanks in advance.
Reply With Quote
  #2  
Old 08-09-2016, 06:56 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Calculate average age Windows 7 64bit Calculate average age Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post a sample sheet ( no pics please). So we can see what you have
__________________
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
Reply With Quote
Reply

Tags
age, average, excel 2016

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate average age Calculate Average Time Elapsed in Days, hours and minutes Nina46 Excel 9 09-11-2015 02:09 AM
Average for the month joflow21 Excel 4 10-21-2013 06:57 AM
'AVERAGE' Formula nfphilpot Excel 3 11-24-2010 02:19 PM
Calculate average age Average of many rows speedycorn1 Excel 1 10-30-2010 07:54 PM
calculate average depending on drop-down values virencm Word 0 08-06-2010 06:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft