Sum values over range of dates

[bbronshteyn]

Need Help!!!! PLEASE!

Here is the example...

If I have a huge table of dates and values for those dates and need
to
sum based on a given date range, how do I sum it up?

date 1 date 2 date 3 date 4 date 5
Sate 1 12 7 8 1 1
State 2 10 4 6 2 8
State 3 5 4 2 3 7

start date end date Sum would be???
Sate 1 2 5 17
State 2 1 3 20
State 3 2 4 9

But what is the formula I can use for this??? How can I set it up so I
just need to change start and end dates and it will calculate
automatically???? Please help!
Thank You!!!!

 

[T. Valko]

Assume:

This data is in the range A1:F4.

date 1 date 2 date 3 date 4 date 5
Sate 1 12 7 8 1 1
State 2 10 4 6 2 8
State 3 5 4 2 3 7

This data is in the range A10:C12.

Sate 1 2 5
State 2 1 3
State 3 2 4

Enter this formula in D10 and copy down as needed:

=SUM(OFFSET(A$1,MATCH(A10,A$2:A$4,0),B10,,C10-B10+1))

Screencap:

http://img502.imageshack.us/img502/6118/sumtableit3.jpg