hlookup multiple values

[stuckagainexcel]

I have the data below I want to add all the values that match a certain date in a pair of column below, if the dates didn't duplicate I could do a hlookup but as they do, I'm a bit stuck.

For example my input would be "13/9/2021" and I would want the output in separate cells to show:

Row 1 total: 80
Row 2 total: 50
Row 3 total: 0
Row 4 total: 0
Row 5 total: 36
Row 6 total: 17

Input
Date	13/09/2021​	13/09/2021​	21/09/2021​	21/09/2021​	21/09/2021​	21/09/2021​
Row 1	46​	34​	4​	18​	28​	35​
Row 2	32​	18​	4​	19​	10​	26​
Row 3	0​	0​	0​	3​	0​	0​
Row 4	0​	0​	7​	10​	0​	10​
Row 5	6​	30​	0​	0​	0​	0​
Row 6	0​	17​	0​	0​	0​	0​

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1	Input
2	Date	13/09/2021	13/09/2021	21/09/2021	21/09/2021	21/09/2021	21/09/2021
3	Row 1	46	34	4	18	28	35
4	Row 2	32	18	4	19	10	26
5	Row 3	0	0	0	3	0	0
6	Row 4	0	0	7	10	0	10
7	Row 5	6	30	0	0	0	0
8	Row 6	0	17	0	0	0	0
9
10
11	13/09/2021
12	Row 1	80
13	Row 2	50
14	Row 3	0
15	Row 4	0
16	Row 5	36
17	Row 6	17
Master

Cell Formulas
Range	Formula
B12:B17	B12	=SUMIFS(B3:G3,$B$2:$G$2,$A$11)