Sum a column by the header name

[kevin440red]

How can I sum a column header by it's name? The column header will move to different columns from time to time.
The formulas I will use is below

=MAX(U10:U32)
{=MIN(IF($U$10:$U$32>0,$U$10:$U$32))}
=MAX(U10:U32)

Thanks

 

[Fluff]

If your data is in a structured table you can use

+Fluff v2.xlsm
	A	B	C	D	E
1	name	score
2	a	0		Max	16
3	b	-3		Min	5
4	c	6
5	d	7
6	e	15
7	f	-4
8	g	-2
9	h	0
10	i	11
11	j	0
12	k	10
13	l	5
14	m	13
15	n	-1
16	o	15
17	p	8
18	q	16
19	r	-3
20	s	-4
Sheet1

Cell Formulas
Range	Formula
E2	E2	=MAX(Table1[score])
E3	E3	=MIN(IF(Table1[score]>0,Table1[score]))
Press CTRL+SHIFT+ENTER to enter array formulas.