SUMIFS with AND conditions; between two dates

[dchubbock]

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

[Jonmo1]

I think you have your > and < symbols reversed.

[dchubbock]

Ahem. you may well be onto something. Is there a way to delete a thread to save blushes?!?

(Thank you)

[Tony Valko]

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

You're using the same criteria for both conditions.

[Jonmo1]

No, it's too late. It's out there for the world to see.

Don't worry though, it happens to the best of us.
Sometimes it just takes another set of eyes.

[dchubbock]

Thanks i feel a little better now