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:
=DATEDIF(AVERAGE(C2: C10),TODAY(),"y")
|
(please let me know if I did it wrong). But for male and female I failed to do it in a nested way.
In case any of you drop a hint, a thousand thanks in advance!