Excel sumif function

[hawk-I]

I would really like to compare to a value in a cell in the "criteria" argument of a sumif function in Excel 2003: =SUMIF(L2:L8,"<L5",K2:K8).
Somehow, it doesn't do the comparison "greater than the value in L5". I've tried all sorts of syntaxes. Any help on this would be much appreciated.
--Pierre

 

[Hawkeye22]

I don't think you need quotes around the criteria unless it's text.

Check out some examples of sumif here.

http/www.contextures.com/xlFunctions01.html