You can use something along the lines of the following:

=SUMIF(A1:A16,$D$1&"=10")
where D1 is absolutely refernced or
=SUMIF(A1:A16,D1&"=10")
if relative

--
Kevin Backmann


"Garver" wrote:

I am looking to use the conditional sum feature for summing a range of data
based on a criteria of course, but I am looking to be able to set the
criteria to a cell value so that I can drag the conditional sum to other
cells and have it calcuate accordingly. Any ideas?