Add accounts and account totals automatically at bottom of petty cash envelope

[OBA]

Hi,

This may seem like allot to ask but wondering if anyone might have some insight.

I have a petty cash report (attached) with different lines for entries. When the person submits it, the accountant will designate account#'s to each line under the ACCT USE ONLY cell for that line. EX. 2245 (lets say this is for office supplies)

Then at the bottom of the petty cash report there are lines for summarizing the account totals on the report.

Now there are maybe 100's of different account #'s from 0001 - 8467 as an example and typically on a report 5-7 different accounts would be used, some multiple times.

What I'm wondering is if there is a way automatically add all the totals for each account at the bottom. This would mean posting each account number that is listed above in the report, then adding all the other accounts with that same account number at the bottom.

In the image attached I have put in few example entries and shown them adding at the bottom.

I hope I explained this clearly, If anyone can help me figure this out it would be incredible!

Screen Shot 2014-07-02 at 10.14.13 PM.png

[protonLeah]

Post the workbook

[OBA]

OBA_Petty Cash Envelope_ADDS.xlsx

Here is the worksheet