Returning a value based on a date falling between dates in 2 columns with matching criteria

[ryanmorris18921892]

I want return the daily velocities (column K) into the grid I've got. The values in the grid M4:P4 and down are examples I plugged in. I need the date in column L to fall between the dates in G & H and then M3:P3 to match what the retailer is in column E. Thanks!

 

[jasonb75]

Try this in M4, drag right and fill down as needed (untested).

=IFERROR(1/(1/SUMIFS($K:$K,$E:$E,M$3,$G:$G,"<="&$L4,$H:$H,">="&$L4)),"")

 

[ryanmorris18921892]

Try this in M4, drag right and fill down as needed (untested).

=IFERROR(1/(1/SUMIFS($K:$K,$E:$E,M$3,$G:$G,"<="&$L4,$H:$H,">="&$L4)),"")

Spot on, cheers pal