SUMIF with multi column range?

Hi

i am trying to insert a simple SUMIF function but cannot get it to work.

i need to add the values in range R5:R250, only if the number 1715 appears in range L5:M250

I can get it to work on a single column =SUMIF(M5:M250,1715,R5:R250) this works, however if i change to =SUMIF(L5:M250,1715,R5:R250) returns 0.

Any help would be greatly appreciated, Thanks