SUM formula referencing dates

Question

I need a SUMIF formula that will draw from the left table and provide a sum of the data between the dates FROM:TO and fill out the fields in bold in the right table. I've been trying to use SUMIF to make it work, but haven't been able to make it function.&nbsp;How can I do this?&nbsp;DateData1Data2&nbsp;&nbsp;FromToWeekSUM Data1 btw FROM:TOSUM Data2 btwFROM:TO01-07-1921&nbsp;&nbsp;01-07-1902-07-191&nbsp;&nbsp;02-07-1942&nbsp;&nbsp;08-07-1914-07-192&nbsp;&nbsp;03-07-1953&nbsp;&nbsp;15-07-1921-07-193&nbsp;&nbsp;04-07-1964&nbsp;&nbsp;22-07-1928-07-194&nbsp;&nbsp;05-07-1975&nbsp;&nbsp;29-07-1904-08-195&nbsp;&nbsp;06-07-198.46&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;07-07-199.67&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;08-07-1910.88&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;09-07-19129&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10-07-1913.210&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11-07-1914.411&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12-07-1915.612&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;13-07-1916.813&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14-07-191814&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15-07-1919.215&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16-07-1920.416&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17-07-1921.617&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18-07-1922.818&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19-07-192419&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

riny_van_eekelen · Accepted Answer

BMB199&nbsp;Based on your example, assuming the top left corner is in A1 and the "Sum Data 1"-formula to be entered in I2, like this:=SUMIFS(B$2:B$20,$A$2:$A$20,"&gt;="&amp;$F2,$A$2:$A$20,"&lt;="&amp;$G2)&nbsp;Copy down and across.&nbsp;&nbsp;

Forum Discussion

SUM formula referencing dates

1 Reply

Resources

Date	Data1	Data2	From	To	Week	SUM Data1 btw FROM:TO	SUM Data2 btw FROM:TO
01-07-19	2	1	01-07-19	02-07-19	1
02-07-19	4	2	08-07-19	14-07-19	2
03-07-19	5	3	15-07-19	21-07-19	3
04-07-19	6	4	22-07-19	28-07-19	4
05-07-19	7	5	29-07-19	04-08-19	5
06-07-19	8.4	6
07-07-19	9.6	7
08-07-19	10.8	8
09-07-19	12	9
10-07-19	13.2	10
11-07-19	14.4	11
12-07-19	15.6	12
13-07-19	16.8	13
14-07-19	18	14
15-07-19	19.2	15
16-07-19	20.4	16
17-07-19	21.6	17
18-07-19	22.8	18
19-07-19	24	19