How to Find Total Inventory Value at a Specific Location

Learn how to calculate the total inventory value at a specific location using filters and the SUM formula in Google Sheets or Excel.

Written by Yujia Zheng
October 14, 2024

Step 1: Export Inventory

• Navigate to the Import/Export page in ARTERNAL and select Export Inventory.
• After downloading the spreadsheet, open it in Google Sheets or Excel.

Step 2: Create a Filter in Your Spreadsheet

• In your spreadsheet (example uses Google Sheets)

Click on Data > Create a Filter.

Step 3: Filter by Location

• Go to the Location column, uncheck the locations you don't want to include, and click OK to apply the filter.

• Delete all the filtered rows (those not needed for the calculation).

Step 4: Select Remaining Location

• Go back to the Location column and select the only remaining location.
• Click OK to finalize the filter.

Step 5: Calculate the Total Inventory Value

• Under the Price column, use the SUM formula to calculate the total inventory value for the selected location.

Frequently Asked Questions (FAQ):

Q: How do I export my inventory in ARTERNAL?
A: Go to the Import/Export page and click Export Inventory to download your inventory data as a spreadsheet.

Q: How do I filter my spreadsheet by location?
A: In your spreadsheet (Google Sheets or Excel), click Data > Create a Filter, then uncheck the locations you don’t need and click OK.

Q: How do I calculate the total inventory value for one location?
A: After filtering by location, use the SUM formula in the Price column to calculate the total inventory value.