Thread: [Solved] Calculate average age
View Single Post
 
Old 08-09-2016, 06:47 AM
FTL FTL is offline Windows 8 Office 2016
Novice
 
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