Using Titles of rows to sum date in columns.....

[kgray28]

Hi

I have a spreadsheet, with a lot more data than below spanning quite a few years. I want to add a summary page to show the totals by individual by year. As it's a moving piece i didn't want to put a YTD total on and use a sumif, i was wondering if there is a way of looking across a row and picking up all the 2019's by Boris and summing it?

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]2019[/TD]
[TD]2019[/TD]
[TD]2018[/TD]
[TD]2018[/TD]
[/TR]
[TR]
[TD]Boris[/TD]
[TD]400[/TD]
[TD]400[/TD]
[TD]6500[/TD]
[TD]600[/TD]
[/TR]
[TR]
[TD]Carly[/TD]
[TD]500[/TD]
[TD]6500[/TD]
[TD]3000[/TD]
[TD]800[/TD]
[/TR]
[TR]
[TD]Megan[/TD]
[TD]640[/TD]
[TD]502[/TD]
[TD]5031[/TD]
[TD]160[/TD]
[/TR]
[TR]
[TD]Harry[/TD]
[TD]514[/TD]
[TD]545[/TD]
[TD]6565[/TD]
[TD]555[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about

Book1
	A	B	C	D	E	F	G	H	I
1		2019	2019	2018	2018			2019	2018
2	Boris	400	400	6500	600		Boris	800	7100
3	Carly	500	6500	3000	800		Megan	1142	5191
4	Megan	640	502	5031	160
5	Harry	514	545	6565	555
List

Cell Formulas
Range	Formula
H2	=SUMPRODUCT(($A$2:$A$5=$G2)*($B$1:$E$1=H$1),$B$2:$E$5)

 

[Peter_SSs]

Not entirely clear but is this, copied across and down any help?
If not, more details/explanation/examples please.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1		2019	2019	2018	2018				2019	2018
2	Boris	400	400	6500	600			Boris	800	7100
3	Carly	500	6500	3000	800			Carly	7000	3800
4	Megan	640	502	5031	160			Megan	1142	5191
5	Harry	514	545	6565	555			Harry	1059	7120
Totals

 

[kgray28]

This has worked perfectly!!

Thank you so much! I didn't even think of a SUMPRODUCT!

 

[Peter_SSs]

I see you have a successful outcome but I had missed the point in your thread title "Using Titles of rows" so for completeness this would be the adaptation of my earlier suggestion.

Excel Workbook
	A	B	C	D	E	F	G	H	I
1		2019	2019	2018	2018			2019	2018
2	Boris	400	400	6500	600		Boris	800	7100
3	Carly	500	6500	3000	800		Megan	1142	5191
4	Megan	640	502	5031	160		Harry	1059	7120
5	Harry	514	545	6565	555		Carly	7000	3800
Totals

 

[Fluff]

This has worked perfectly!!

Thank you so much! I didn't even think of a SUMPRODUCT!

You're welcome & thanks for the feedback