Sure.

1) I'm using Excel 2007, Mac Version

2)

Column A Column B Column C Column D Column E Column F Column G
Row 1 Card Number Student Jan. Deposit Statement Card # $ Amount Sorted # Sorted $ Amount
Row 2 111 Tom 444 10
Row 3 222 Dick 555 10 222 10
Row 4 333 Harry 555 20
Row 5 444 George 555 10 444 10
Row 6 555 Henry 222 10 555 10

In this simplified example, my goal is to have the formula in column F sort out the numbers in column D (I already have a formula to do this), and have the formula in column G sort the values from column E, adding together the values for each instance of the card.

I made this example to show that the way I have the formula written now, Column G works fine EXCEPT in the instance of card 555. Because card 555 was used 3 times, once for $20 and twice for $10, cell H6 should read $40, but the way my formula's written now, it only reads the first instance of card 555, $20. Once I get the formula right, I plan to use column D-G as work space. I will paste raw data from monthly statements into columns D and E, columns F and G will sort and calculate, and I would then cut and paste the values from column G to the months deposit columns (in this example, column C).

For this example, the formulas would read:

Column F: =IF(ISNUMBER(MATCH(A2,D:D,0)),A2,"")
Column G: =IF(ISNUMBER(MATCH(A2,F:F,0)),OFFSET(INDIRECT("D"& MATCH(A2,D:D,0)),0,1,1,1),"")

I hope this is what you were looking for with a dummy example. If you'd like a truer reflection of what my sheet looks like, let me know.