I would like to sum values in one column if a date falls within two other dates in separate columns. Here's what i have (but it's not working):

=SUMIFS('SF Data'!V:V,'SF Data'!K:K,">="&Sheet1!A2,'SF Data'!L:L,"<="&Sheet1!A2)

Column V are the values i want to sum
SF Data K:K is the column with a start date
SF Data L:L is the column with an end date
Sheet1 A2 is the date value

I would like to Sumif A2 falls within the date range (ie start and end date- inclusive)

Any help appreciated