Can I use a cell reference in the criteria for the sumif function.

G

Guest

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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top