Issues with acct payable spreadsheet - issues with matching totals to respective accts.

Hello all,

*Disclaimer* I did not create this spreadsheet. It is a template I downloaded from a website to use for my job because I am not very experienced with Excel.

If you see the attached example file (this is made up data)...what I am trying to do is figure out the 'Total Accounts Payable' amount for Vendor/Supplier, ABC. I know that I must apply a filter to the 'Vendor/Suppliers' cell to isolate this information...but when I do this, the 'Total Accounts Payable' cell goes away. How can I adjust this so that I can see what the 'Total Accounts Payable' amount is for each respective Vendor/Supplier?

Sorry if this is the wrong thread...

Thank you in advance.