Excel sumif function

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.
1 answer Last reply
More about excel sumif function
  1. I don't think you need quotes around the criteria unless it's text.

    Check out some examples of sumif here.

Ask a new question

Read More

Office Excel 2003 Excel Apps