This article may be out of date!
Visit the New Knowledge Center

How to Filter an Expense Export in Excel to See Totals Based on Specific Expense Codes


  • See total for Expenses with a particular UTMBS Code
  • View all Expenses with E or X Codes


  • Excel

Additional Information:


  1. Create a CSV Export of Expenses using the steps here
  2. Open the file in Excel
  3. Optionally, remove an unnecessary column by right-clicking on the column and choosing Delete
  4. Click in the top-leftmost cell (A1)
  5. While holding the Shift key, click on the bottom-rightmost cell of the range
  6. Select the Home ribbon
  7. Choose Format as Table
  8. Select a formatting option
  9. Check the box beside My table has headers
  10. Click OK
  11. Right click anywhere in the table
  12. Choose Table > Totals Row
  13. Click on the dropdown arrow at the top of the UtbmsExpense column
  14. Uncheck Select All
  15. Check the boxes for the codes that you would like to include
  16. In the Total row, click into the Total column
  17. Click on the dropdown arrow that appears and choose Sum


Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality