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.

Does help, and often simplifies things, when you get more little details like
that, doesn't it. Thanks for jumping in with that one.

"T. Valko" wrote:

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.

Yeah, the devil is in the details!

--
Biff
Microsoft Excel MVP


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Does help, and often simplifies things, when you get more little details
like
that, doesn't it. Thanks for jumping in with that one.

"T. Valko" wrote:

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.

On Sun, 3 Feb 2008 14:31:46 -0500, "T. Valko"
wrote:

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)


Thank you. I think this simplicity will help me a lot. I understand
tho that others may not have been able to help me without more details
and I apologize for that but in my defense when you are totally
ignorant, it's hard to know which details are necessary to give :( .

This newsgroup is still a nice bunch of people 'cause they don't tell
you how stupid you are for asking a question (like myself in this
case). Always appreciate this newsgroup for their wealth of
knowledge, willingness to offer it for free and in a short time.

Thank you to all of you for the help!

Not a real problem, we realize that often people don't know what's important
or pertinent and what's not. There's also often a 'vocabulary' problem,
which we deal with as needed (example: you don't have lines around a cell,
you have borders).

And sometimes we even find ourselves at the other end of the pendulum swing:
so much information that it's hard to pick out what's important and what's
not.

As far as anyone claiming a question is a dumb one - not in these forums.
The whole concept is to assist users of all experience/skill levels in Excel,
and we often get the first-time user. The idea here is to share our
experience and knowledge, not tell others how much 'smarter' we are than they
are. It's not a question of 'smarts'; it's a matter of experience with the
tool.

I'm simply glad that a good solution was found for you.

"observer" wrote:

On Sun, 3 Feb 2008 14:31:46 -0500, "T. Valko"
wrote:

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)


Thank you. I think this simplicity will help me a lot. I understand
tho that others may not have been able to help me without more details
and I apologize for that but in my defense when you are totally
ignorant, it's hard to know which details are necessary to give :( .

This newsgroup is still a nice bunch of people 'cause they don't tell
you how stupid you are for asking a question (like myself in this
case). Always appreciate this newsgroup for their wealth of
knowledge, willingness to offer it for free and in a short time.

Thank you to all of you for the help!

Jerry summed it up nicely.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Not a real problem, we realize that often people don't know what's
important
or pertinent and what's not. There's also often a 'vocabulary' problem,
which we deal with as needed (example: you don't have lines around a cell,
you have borders).

And sometimes we even find ourselves at the other end of the pendulum
swing:
so much information that it's hard to pick out what's important and what's
not.

As far as anyone claiming a question is a dumb one - not in these forums.
The whole concept is to assist users of all experience/skill levels in
Excel,
and we often get the first-time user. The idea here is to share our
experience and knowledge, not tell others how much 'smarter' we are than
they
are. It's not a question of 'smarts'; it's a matter of experience with
the
tool.

I'm simply glad that a good solution was found for you.

"observer" wrote:

On Sun, 3 Feb 2008 14:31:46 -0500, "T. Valko"
wrote:

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)


Thank you. I think this simplicity will help me a lot. I understand
tho that others may not have been able to help me without more details
and I apologize for that but in my defense when you are totally
ignorant, it's hard to know which details are necessary to give :( .

This newsgroup is still a nice bunch of people 'cause they don't tell
you how stupid you are for asking a question (like myself in this
case). Always appreciate this newsgroup for their wealth of
knowledge, willingness to offer it for free and in a short time.

Thank you to all of you for the help!