View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hkaempffe hkaempffe is offline
external usenet poster
 
Posts: 1
Default How do I sum between any two entered values in a vlookup table

Have a table with days of the year(in sequence) in column 1 and values in
columns 2 -7 I want to enter any two dates and using a vlookup sum the data
in column two

Columns
1 2 3 4 5 6
7

1 Jan 06 24 6 5
2 Jan 06 12 8 2
3 jan 06 0 20 4
4 jan 06 20 6 5

enter 1 Jan and 4 jan the answer = 56