Sumifs with an IF statement, or using an Array (not working)

[SandyG]

I have a worksheet that I'm tracking labor hours with. I have 1 tab that all the hours are inputted into, then it filters to a few different tabs. There is a budget, and one of the tabs has a burndown of money available and how quickly we will go through it.

For my formula, I'm basically telling it, to look in the other tab using a date range, and if that range is empty, place "40" in the field, otherwise, total up the hours in the date range. I have multiple employees that need to be tracked.

I wrote an array formula, but it only works in the first cell. I copied the formula across cells and down rows for the other employees, but the formula is not working in those cells. Only works in the first cell.

Here is the formula.

=IF('Labor - Daily Hours'!$D$53:$D$190 = "","40",(SUMIFS('Labor - Daily Hours'!$B$3:$B$189,'Labor - Daily Hours'!$A$3:$A$189,">=5/21/2018",'Labor - Daily Hours'!$A$3:$A$189,"<=5/27/2018")))

This array formula is in D10. It's carried down (D11, D12, etc) for the same employee, but it only works in D10.

This is the same array formula in E10 (just columsn changed in formula for next employee), but it's not working. If I just hit enter, instead of ctrl, shift & enter, I then get a #value error. It's carried across (E10, F10, etc). Each one is an array.

Is there another formula that would work better? What am I doing wrong with the array?

 

[SandyG]

I figured it out after I posted... If I can, I will delete this thread.... Thanks to anyone that looked!