Correction:

This formula will handle both situations

The formula will work on *relative* row numbers. But, if your data really is
in A1:B10 then it'll work in that situation also.

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Ok, do you want to input the actual row numbers or the *relative* row
numbers? Relative meaning as it relates to the row numbers of the table no
matter where the table is?

For example, if your data is as you say in A1:B10 and you want to sum row
1 then A1 and B1 would be summed. If your data is A22:B32 and you want to
sum row 1 *relative* to the table then the sum would be A22:B22.

This formula will handle both situations but we can shorten it slightly if
you want the *actual* row numbers.

Assume you enter the row numbers in the range D1:D3

=SUMPRODUCT((ISNUMBER(MATCH(ROW(A1:B10)-MIN(ROW(A1:B10))+1,D1:D3,0)))*A1:B10)

--
Biff
Microsoft Excel MVP


"David" wrote in message
...
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.