I'm creating an expense reimbursement form. I have 2 columns that need to "work together." There are approx. 10 rows. The first column is a drop down list of account numbers (12 #s). The second column is a dollar amount (user entered). I need 12 "fields" (one for each acct. #) that will look at all the fields in column 1 and add up the dollar amounts in column 2 if the column 1 data matches.
Example:
Column 1 Column 2
Acct. 12345 $10.00
Acct. 67890 $5.00
Acct. 12345 $20.00
Acct. 12345 Total: $30.00
Acct. 67890 Total: $5.00
Thanks for the help!