View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
observer observer is offline
external usenet poster
 
Posts: 10
Default 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!