This can be done. Something like:

=SUMIF(A1:A10,C1,B1:B10)

This checks for the value of C1 in the range A1:A10, then adds B1:B10.

HTH,
Elkar


"Michael" wrote:

I am trying to use the cell contents as the Criteria specification as opposed
to a fixed text operator and cannot seem to figure out how to do it or if it
can be done.