Range 2005 2006 2007
0-$99 $500.00 $200.00 $2,500.00
$100-249 $2,500.00 $500.00 $5,000.00
$250-499 $6,000.00 $900.00 $2,500.00
$500-999 $1,000.00 $2,500.00 $5,000.00
$1,000-2,499 $25,000.00 $16,000.00 $2,500.00
$2,500-4,900 $60,000.00 $50,000.00 $30,000.00
$5,000-4,999 $90,000.00 $70,000.00 $50,000.00
$10,000 + $80,000.00 $70,000.00 $100,500.00

I have a spreadsheet full of individual financial transactions from
2005 to 2007, Amount and Date. I need the columns to be the sum of
the values per year and the rows to be the various financial levels.
I'm not sure how to group the transactions within the monetary
ranges. Any help would be appreciated.