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?

	2019	2019	2018	2018
Boris	400	400	6500	600
Carly	500	6500	3000	800
Megan	640	502	5031	160
Harry	514	545	6565	555

<tbody>
</tbody>

 

[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