google spreadsheet - How do I make a formula to take the sum of data corresponding to dates only in a 2-week time period? -

google spreadsheet - How do I make a formula to take the sum of data corresponding to dates only in a 2-week time period? -

hi there,

i'm new stack overflow. have hobbyist-level knowledge of web coding (html, css, php, etc.) , making spreadsheets things me.

but, can't seem figure out how next in google sheets:

(first off, sheet1 simple calculations on sheet linked google form user inputs info on work shifts.)

out of sheet1, select date values in column (date) fall on or between pay period start , end dates on sheet2 (e.g. sheet2!b2 [2014-09-28] , sheet2!c2 [2014-10-11]), and

then, date values in sheet1 column on or between sheet2!b2 & sheet2!c2, take sum of corresponding info in sheet1 column b (hours) (e.g. 2014-09-28 → 3.75, 2014-09-29 → 3.75 … 2014-10-05 → 4.00), ,

do same info in sheet1 columns e & f (tips & deliveries).

anyone know? thanks!

screenshots of each sheet here:

sheet1

sheet2

google forms sheet

i figured out. in d2 of sheet2, wrote formula:

=sumifs('sheet1'!b:b, 'sheet1'!a:a, ">="&b2, 'sheet1'!a:a, "<="&c2)

google-spreadsheet spreadsheet