Return Totals from Certain Criteria
 

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

Return Totals from Certain Criteria
 

For 1-10

=sumif(am15:am830,"<11",d15:d30)

or for 11-17

=sumif(am15:am830,"10",d15:d30)-sumif(am15:am830,"17",d15:d30)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515078

Return Totals from Certain Criteria
 

=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

Return Totals from Certain Criteria
 

THANKS...WORKS GREAT! GOt one more for you if possible:
Cell C17 contains a certain number of years
D17 contains a dollar figure
These represent a pledge amount that is payable over the specified number of
years.

If the person chooses to make WEEKLY payments over that time period, I want
to be able to put an X in cell K17 and have cell L17 calculate the weekly
payment based upon the amount and number of total weeks in the years
specified in cell C17. In cells M17 and N17, same scenario except for
MONTHLY PAYMENTS over the specified number of years...in cells O17 and P17
same scenario except QUARTERLY PAYMENTS over the same number of years...and
in cells Q17 and R17, annual payments over the same number of years.

Whew! Any thoughts?


"Sloth" wrote:

=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

Return Totals from Certain Criteria
 

=IF(K17="X",D17/C17/52,"")

=IF(M17="X",D17/C17/12,"")

=IF(O17="X",D17/C17/4,"")

=IF(Q17="X",D17/C17,"")

"JT" wrote:

THANKS...WORKS GREAT! GOt one more for you if possible:
Cell C17 contains a certain number of years
D17 contains a dollar figure
These represent a pledge amount that is payable over the specified number of
years.

If the person chooses to make WEEKLY payments over that time period, I want
to be able to put an X in cell K17 and have cell L17 calculate the weekly
payment based upon the amount and number of total weeks in the years
specified in cell C17. In cells M17 and N17, same scenario except for
MONTHLY PAYMENTS over the specified number of years...in cells O17 and P17
same scenario except QUARTERLY PAYMENTS over the same number of years...and
in cells Q17 and R17, annual payments over the same number of years.

Whew! Any thoughts?


"Sloth" wrote:

=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