View Single Post
  #1   Report Post  
Number Cruncher
 
Posts: n/a
Default Can I use a cell reference in the criteria for the sumif function.

If I use "32" as the criteria in my sumif formula, I receive the correct
answer.

If I use C3 as the critera, I receive zero as the answer.

Is some way to use a cell reference in the criteria? Excel help says that
the criteria can be a "number, expression, or text."