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