the numbers are decreasing in value as you
go down the column

Sum values in column A that are between 2 boundaries (inclusive):

99
87
66
59
50
49
28

C1 = 87
D1 = 49

=SUMIF(A1:A7,"<="&C1)-SUMIF(A1:A7,"<"&D1)


--
Biff
Microsoft Excel MVP


<observer wrote in message
...
Let me restate an earlier post so maybe its easier to understand...

I want to use vlookup for 2 values in a column and then I want to be
able to add them and all the numbers in between them (in that column)
to another cell. Can this be done and how? Please no VBA as I'm
not familiar with it. Thanks.