#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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 |
Tags |
age, average, excel 2016 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |