Having a little trouble

[Not so quick]

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I am working on a project that will pull, calculate and summarize years of Aircraft maintenance history, by typing in two dates on a summery sheet but I am stuck on a formula.<o></o>
On tab one I have a row of dates (past 5 years) in 3:3 and Data in the subsequent rows.<o></o>
On tab two I have a summery sheet with two dates at the top. The idea is to type in any two dates on the summery sheet and have all the information on that page update with data totals between the two dates (Jan09-Mar10). I put a summary column at the end of my data on tab one. I then put a look up formula in that column with a look up value =the cell on the top of my summery sheet on tab one. I then selected a vector of 3:3 to find a matching date and a result vector in the row that had the corresponding data I wanted to add. Then I did the same thing with the second date. I wanted it to sum the data between the two dates. Here is the formula I used.<o></o>
=SUM(LOOKUP(Cumulative!C2,3:3,14:14):LOOKUP(Cumulative!C2,3:3,14:14))<o></o>
It can't get it to sum the range of data between two look-up points. I can get it to add the data for the two dates if I change the : to a , .<o></o>
I am not a pro and any assistance would be greatly appreciated.<o></o>

 

[jbeaucaire]

Something like this... tab 2 has the dates, tab 1 has a "summary column" (column L in this example) that totals the columns with the date range from tab2.

Excel Workbook
	A	B
1
2	Start	5/1/2011
3	End	5/5/2011
4
Tab2

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
2
3	Date	4/29/2011	4/30/2011	5/1/2011	5/2/2011	5/3/2011	5/4/2011	5/5/2011	5/6/2011	5/7/2011		Summary
4		2	3	4	2	2	4	2	4	5		14
5		1	5	4	6	7	2	8	4	6		27
6
Tab1

 

[Not so quick]

I added the formula you provided and it worked perfect!!!! I left the ends open for the sum of rows for when we add need data columns each month. I tried the IFSum formula first but i was leaving the & out and never got it to work and moved to the look-up formula. I guess you can't sum look-up because excel is identifying the data in the cells and not the sells themselves and in return cant sum the cells between the two points? I read your formulas and understand it...thanks for the greatest gift (knowledge)

THANKS!!!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>