SUMIFS with a date

[gemexcel]

Hello,

I have a formula - SUMIFS('Summary 2016'!$E:$E,'Summary 2016'!$B:$B,CONCATENATE(L4," ",M$3)) which works perfectly well but when I try and add a date criteria I get an error message or zero.

e.g. =SUMIFS('Summary 2016'!$E:$E,'Summary 2016'!$B:$B,CONCATENATE(L4," ",M$3),'Summary 2016'!$A:$A,"=<L$2")
I have also tried;
'Summary 2016'!$A:$A,"=<"L$2)
'Summary 2016'!$A:$A,"=<"&L$2)

L2 = 01/01/16

Summary 2016 A:A = column with first of the month dates for 2016 e.g. 01/01/16 & 01/02/16

Can anyone help me correct this formula?

Thank you

 

[gaz_chops]

Try swapping "=<" for "<="

'Summary 2016'!$A:$A,"<="&L$2)

 

[gemexcel]

Thank you that works perfectly. What a silly error by me!

 

[gaz_chops]

You're welcome.