Unfortunately the criteria changes so defining which rows to sum is the
preferred way to go about it.

Hope that helps.

"T. Valko" wrote:

Why don't you tell us what the criteria is and we can eliminate the need to
input row numbers.

--
Biff
Microsoft Excel MVP


"David" wrote in message
...
I have two columns (assume A1:B10) that contain specific results. Of those
results, some data is within a specification and some is not. I want to
be
able to input which rows are to be summed in a cell and then the summed
rows
result in another.