SUMIFS with less than & more than

[stepan1987]

Hi guys,
I have a range of figures with a range of dates. I also have to cells where I input starting date and end date. I need my sumifs formula sum all the values between two dates.
Now I have the following:
=SUMIFS('Trade Search Results'!Y:Y;'Trade Search Results'!D:D;'Portfolio stats'!B16;'Trade Search Results'!AN:AN;"<=$L$3";'Trade Search Results'!AN:AN;">=$L$2")

where Y:Y are values
D:D is a range with company names and B16 is the needed company
AN:AN is a range of dates
L2 is start date
L3 is end date

Now it keeps looking for dates that are equal or less that "$L$3" and equal or more than "$L$2", not the date in the cell.

How can I change it?

Thanks!

 

[stepan1987]

P.S. when i input needed dates instead of the cell address it works just fine

 

[Marcelo Branco]

Hi,

Try
"<="&$L$3 instead of "<=$L$3"
and
">="&$L$2 instead of ">=$L$2"

HTH

M.

 

[stepan1987]

Cool, it did help, thanks man!

 

[Marcelo Branco]

Cool, it did help, thanks man!

You are welcome and tks for the feedback

M.

 

[muzikman69]

Great workaround, thank you as well.

Cheers,
Graeme,