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
More aboutexcel sumif function
I don't think you need quotes around the criteria unless it's text.