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:

(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!