Sum(Index)(Match)

[Guzzlr]

Hello, here's a short example of data:
In Column L4 I have: =SUM(INDEX(E:H,MATCH(K4,E:E,0),0))
What I want to sum, is if the date in K4 is found in Column E, then all the numbers in Column G:H are added, which should be 12.
I wanted to use SUMIF, but got no where with that!
Can someone tell me what I'm doing wrong please...
Thank you for your help

Column E	Column F	Column G & H (Merge & Center)	Column I & J (Merge & Center)	Column K	Column L
1/3/2022	0:00			1/3/2022	44564
1/3/2022	1:00				0
1/3/2022	2:00				0
1/3/2022	3:00				0
1/3/2022	4:00				0
1/3/2022	5:00	1			0
1/3/2022	5:30	1			0
1/3/2022	6:00	1			0
1/3/2022	7:00	1			0
1/3/2022	8:00	1			0
1/3/2022	9:00	1			0
1/3/2022	10:00	1			0
1/3/2022	11:00	1			0
1/3/2022	12:00	1			0
1/3/2022	13:00	1			0
1/3/2022	14:00	1			0
1/3/2022	15:00	1			0
1/3/2022	16:00				0
1/3/2022	17:00				0

 

[Fluff]

Difficult to tell what is wrong with the sumifs you used as you haven't posted it.

 

[Guzzlr]

My SUMIFS formula: =SUMIFS(G:G,G:G,"1",E:E,"1-3-2022")
The reason why I dont like this, is I have to manually type in 1-3-2022.
1-3-2022 is in cell K4.
I haven't had luck installing =K4 in the SUMIFS formula. So now I'm trying the Sum (Index)(Match) instead.

 

[ebea]

Try: =SUMIFS(G4:G22;E4:E22;"="&K4)

 

[Guzzlr]

Try: =SUMIFS(G4:G22;E4:E22;"="&K4)

Working!
Thank you!

 

[ebea]

Your welcome! Mark it as solved, if it works.