adding up vlookup values in one column and in between them
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!
|