Add only if between dates

[Nanaia]

I can't determine whether to use COUNTIF, COUNTIFS, SUMIF, or SUMIFS in this situation. I've tried all four and none do what I want so I'm seeking guidance here.

I'm trying to total items in a column only if the date in the adjacent column is between two dates. Column K is DATE (every day of the year) and I want to add the numbers in column L if the date in column K is between two dates. How do I do this?

 

[DataBlake]

How do I do this?

sounds like what you're trying to do can not be (easily) done in a formula.
loop through each cell in k
If K is between the dates x and y
then add that row's L to the sum
?

if that more or less is the solution that would be VBA

 

[DataBlake]

in which case i will need relevant info like:
- sheet names
- if the dates are located in cells or you want to type them in
- any other info you think is relevant

 

[Fluff]

Maybe something like
=SUMIFS(L:L,K:K,">="&D1,K:K,"<="&D2)
where D1 & D2 hold the two dates