# 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.