Use date range to add data

[Jmmac04]

Hi All~

Here is what I am looking to do. I have a date range in cell A7. Using this date range, I look at the Acc tab and add together the data in columns B C D which equals that date range. I would love to find an automatic way that when I put in my date range, it will calculate the data automatically for me without having to create the sum formula and selecting it each time.

Excel Workbook
	A	B	C	D	E	F
6	DATES	PYMNTS	OWED	PAID	TOTAL OWED	BALANCE
7	6/9/2010- 7/05/2010	24	15	2268	360	1908
8	12/31/09 - 3/14/10	19	19	*	361	-361
9	3/15/10 - 12/31/10	46	22	*	1012	-1012
10	1/1/11 - 4/18/11	26	18	*	468	-468
REC.

Excel Workbook
	A	B	C	D
1	DATE	CHLD CSUP	CHLD CUSTA	CHLD CUSTAI
2	6/9/2010	1	2	3
3	6/10/2010	2	4	6
4	6/11/2010	3	6	9
5	6/12/2010	4	8	12
6	6/13/2010	5	10	15
7	6/14/2010	6	12	18
8	6/15/2010	7	14	21
9	6/16/2010	8	16	24
10	6/17/2010	9	18	27
11	6/18/2010	10	20	30
12	6/19/2010	11	22	33
13	6/20/2010	12	24	36
14	6/21/2010	13	26	39
15	6/22/2010	14	28	42
16	6/23/2010	15	30	45
17	6/24/2010	16	32	48
18	6/25/2010	17	34	51
19	6/26/2010	18	36	54
20	6/27/2010	19	38	57
21	6/28/2010	20	40	60
22	6/29/2010	21	42	63
23	6/30/2010	22	44	66
24	7/1/2010	23	46	69
25	7/2/2010	24	48	72
26	7/3/2010	25	50	75
27	7/4/2010	26	52	78
28	7/5/2010	27	54	81
29	7/6/2010	28	56	84
30	7/7/2010	29	58	87
31	7/8/2010	30	60	90
32	7/9/2010	31	62	93
Acc. Stmnt

Thanks!!

 

[Jmmac04]

I can do everything but get it to add that range it finds... any help would be appreciated!

Thanks