Formula to Calculate Age for Visible Rows

[PMcGinness]

I recently started to enjoy using the subtotal function for some of my student reports (I work in Higher Ed).

I would love to have something where I can age update as I filter by rows. I have a registration date in Column R and a student's DOB in K. I know how to calculate age, but is there a way to have this value to changed based on just my visible rows?

Thanks for any help.

 

[awoohaw]

why do you want to recalculate age based on a visible row(s)? Isn't age the same regardless of the row being visible or not?

 

[PMcGinness]

why do you want to recalculate age based on a visible row(s)? Isn't age the same regardless of the row being visible or not?

I have to report the average age of someone based on what class they are in.

 

[awoohaw]

I have to report the average age of someone based on what class they are in.

okay, I misunderstood your question.

instead of SUBTOTAL use AGGREGATE (and choose to ignore hidden rows).

Mr excel questions 68.xlsm
	A	B	C	D
1		Class	DOB	AGE
2		Class_1	2000-10-27	22
3		Class_2	2003-02-25	20
4		Class_2	2001-03-07	22
5		Class_2	2003-01-29	20
6		Class_1	2002-03-01	21
7		Class_1	2002-05-19	21
8		Class_1	2000-09-14	23
9		Class_2	2000-06-16	23
10		Class_1	2002-04-13	21
11		Class_2	2002-02-19	21
12		Class_1	2002-03-02	21
13		Class_1	2002-11-30	20
14		Class_1	2001-05-16	22
15		Class_2	2003-03-13	20
16		Class_1	2001-07-29	22
17
18		AverageAge:		21.267
PMcGinness

Cell Formulas
Range	Formula
D2:D16	D2	=ROUNDDOWN((TODAY()-C2)/365.25,0)
D18	D18	=AGGREGATE(1,3,D2:D16)