I am looking for a formula or function that will sum columns based on meeting
specific criteria. for example, I have an age table that with a minimum age
column then a maximum age column. I need to be able to enter an age in to a
seperate cell and have Excel sum based on the ages.

Min Max Non Tob Spouse Child EE ADD Sp ADD Ch ADD
15 24 0.46 0.69 0.535 0.679 0.266 0.14 0.072
25 29 0.53 0.78 0.45 0.679
30 34 0.65 0.97 0.49 0.679
35 39 0.9 1.46 0.675 0.679
40 44 1.24 2.19 0.97 0.679
45 49 1.99 3.48 1.52 0.679
50 54 3.05 5.87 2.365 0.679
55 59 4.98 8.28 3.63 0.679
60 64 7.95 12.37 6.205 0.679
65 69 13.95 20.68 10.595 0.679
70 74 25.17 36.36 18.88 0.679
79 50.97 65.77 37.815 0.679