Yes.

It would be handy if you gave some details, but you could have
something like this:

=SUMIF(A:A,""&C1,B:B)

This will add up the values in column B where column A values are
greater than the item in C1.

Hope this helps.

Pete

On Dec 29, 4:33*pm, CSB wrote:
I want the criteria to be a designated cell, is that possible?