Can anyone help me please, I have spent hours today at work trying to comprehend why my fomula isn't working. I am usingExel 2003 and referencingranges from 2 worksheets.

I would post the spreadsheet but am unable to do so from work ad have no external mail.

=SUMIF(Sheet2!$L$4:$L$54,C6,Sheet1!$L$5:$M$54)

If I change the last range to a sinngle column it picks up the value however if I u the L/M range it only picks up the value in column L, anyone know why or what I can do to stop this happening?