Thanks! Works wonders!

"Ron Rosenfeld" wrote:

On Sun, 13 Nov 2005 13:50:06 -0800, "Albie"
wrote:

I am trying to utilize a SUMIF function that references a cell to provide the
the criteria, so that I can changed the criteria inside a optimization or
scenario. My functions are all returning zero when I use the cell reference,
but when I use the actual value, it returns what it should? Any way I can
get around this?

It's just a syntax issue:

=SUMIF(rng_to_check, "=" & cell_ref, rng_to_sum)




--ron