=SUMIF(AM15:AM830,"<=17",D15:D830)-SUMIF(AM15:AM830,"<11",D15:D830)

"JT" wrote:

Using Excel 2003. Column D15 through D830 contains various dollar figures.
Column AM15 through AM830 contains the age of the person contributing the
dollar value in the corresponding D column. I need to return the total value
of contributions by all individuals within certain age ranges, example 1-10
years old...11-17 years old, etc...

Is this a VLOOKUP function? What would the formula look like?

Thanks for the help!

Jack