SUMIF with multi column range?

[Si902]

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

[daddylonglegs]

SUMIF always works on a one to one basis so both ranges must always be the same size. Try using SUMPRODUCT

=SUMPRODUCT((L5:M250=1715)*(0&R5:R250))

Note that if both L5 and M5 contain 1715 that will sum R5 twice, is that OK?

[Si902]

Daddylonglegs, top form as usual!

This works great, 1715 should never appear in the same row twice so this is fine.

Thanks for the great help, im learning slowly but surely.

Cheers.

Si