#1
|
|||
|
|||
Calculate average age (years)
Hi,
I have a task in excel 2007 more or less like this: I am asked to calculate the average age (years) of total, male and female. I was just wondering, is there any way to simply fill in the blanks without generating any extra colomns? I tried a few times, for total average it could be: Quote:
In case any of you drop a hint, a thousand thanks in advance! |
#2
|
||||
|
||||
perhaps something like =sumproduct((datedif(c2:c10,today(),"y"),--(b2:b10="m"))/countif(b2:b10,"m")
for men replace "m" with "f" for women
__________________
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 |
#3
|
|||
|
|||
Quote:
Thank you so much for you reply! I switched the two parts in sumproduct now it works! thank you and hugs!!!!!!!!! |
#4
|
||||
|
||||
You're welcome
__________________
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 |
|
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 |