Petty Cash Envelope - Auto Fill Account Totals

I am looking for a way to automate my petty cash envelope file so that it automatically adds up all expenses with the same account number at the bottom.

I have included an image to better explain
Petty Cash Envelope EXAMPLE.jpg

The workflow is as follows:
- Petty Cash Envelope is submitted with totals from employee (see BLUE area)
- Accountant (me) will enter an account number in the 'ACCT USE ONLY' column beside each expense (see RED area)

Then I would like the bottom Account totals box (Green Area) to automatically add all similar expenses together. This would entail:
- Adding an account number for any account number added in the 'ACCT USE ONLY' area from expense area (only adding 1 instance of each)
- populating the rest of the total for that account with the sum of totals from all similar account numbers in the expenses area
- filling in the description for that account line (descriptions would be on a separate sheet in the excel file along with the account number (see attached chart of accounts)
Example Finished.pdf

Can anyone help me figure this out? If I can get the spreadsheet to auto fill this in it will save me a TON of time and headache. I would be eternally grateful for any help!!

Have also attached the excel file in question.
Petty Cash Rpt .xlsx

Formula in cell H33:

=SUMIF($N$10:$O$29,A33,$V$10:$W$29)

Please see the updated example.


Regards, TMS

Did you see the updated example in Post #3?

OK, here's an amended version.

Regards, TMS

You're very welcome.

Have you thought about what would happen if, in your 20 line items, you have more than 11 unique account numbers? Could that happen?



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

OK, fair enough.

Thanks for the rep.


Regards, TMS