Totaling contributions
 

I have a spreadsheet that tracks contributions from a number of individuals
over several years. I have formulas that look at the number of contributions
in one year vs. the prior year and counts then number of those contributions
that increased...those that decreased...and those that remained the same.

Now I need a formula that looks at those same individuals in the same years
and totals the $ amount of all contributions that increases...decreased...and
remained the same.

Example: column G contains 2006 contributions
Column F contains 2005 contributions

If there are (for example) 53 individuals whose contributions INCREASED in
2006 from 2005, I need to total $ amount contributed in 2006 for those 53
folks.

Same scenario for those invidividuals that DECREASED their contributions in
2006 from 2005

Same scenario for those invidividuals whose contributions REMAINED THE SAME
for both 2006 and 2005.

Any help is GREATLY appreciated.

JT

Column

Totaling contributions
 

if you do a fnction that shows the difference i.e(this year - last year) sort
by name and do a subtotal, for each change in name sum this year, last year,
and deficit

-John

"Jack Taylor" wrote:

I have a spreadsheet that tracks contributions from a number of individuals
over several years. I have formulas that look at the number of contributions
in one year vs. the prior year and counts then number of those contributions
that increased...those that decreased...and those that remained the same.

Now I need a formula that looks at those same individuals in the same years
and totals the $ amount of all contributions that increases...decreased...and
remained the same.

Example: column G contains 2006 contributions
Column F contains 2005 contributions

If there are (for example) 53 individuals whose contributions INCREASED in
2006 from 2005, I need to total $ amount contributed in 2006 for those 53
folks.

Same scenario for those invidividuals that DECREASED their contributions in
2006 from 2005

Same scenario for those invidividuals whose contributions REMAINED THE SAME
for both 2006 and 2005.

Any help is GREATLY appreciated.

JT

Column