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
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 |