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