Sum Values Between Two Dates

KCS

I'm looking for some help with a formula.  I've created a complicated system of sheets where a contractor enters her/his hours into a form each day they work and I link the data into a contractor's individual sheets which then feed into a series of formulas which feed into reports which feed into sights.

What I need to do is to create a formula within each individual sheet that calculates the hour's that that person has worked each week.

So I created a Week Start Date column, a Week End Date column, and a Total Hours worked per week column.  This is the formula I created that keeps coming up #unparseable:

=SUMIFS([NG Hours Worked]:[NG Hours Worked],[NG Date]:[NG Date],[NG Date]>=[AJ Week Start]3,[NG Date]:[NG Date],[NG Date]<=[AJ Week End]3)

NG Hours Worked is a column that has a formula that brings in only the hours that this person worked.  This ultimately comes from the form that this person entered her/his hours.

NG Date is a column is a column that has a formula that brings in the date of the hours that this person worked.  Same source as above.

Everything I look up tells me that my formula is correct, however I cannot get it to work.  Any help would be greatly appreciated!

Thanks

~KC

Chris McKay

You were almost there. Try this in the first cell and drag down:

=SUMIFS([NG Hours Worked]:[NG Hours Worked], [NG Date]:[NG Date], >=[AJ Week Start]1, [NG Date]:[NG Date], <=[AJ Week End]1)

You don't need to refer to the criterion_range again (e.g. [NG Date]) in the criterion (e.g. <=[AJ Week End]1), as you've already established it in the criterion_range.

Hope this makes sense.