Skip to main content
All CollectionsInventory
How to calculate total inventory values at one location
How to calculate total inventory values at one location
Yujia Zheng avatar
Written by Yujia Zheng
Updated over a week ago

Video tutorial HERE.

For insurance or other logistic purposes, if you need to calculate the total inventory value at one location, here's how to do it:

First, go to the Import/Export page and Export Inventory

.

After downloading the spreadsheet, open it in Google Sheets or Excel (the following screenshots are from Google Sheets).

Click on Data > Create a Filter.

Go to the Location column, un-select the location you want to calculate, and click on OK to apply the filter.

Delete all the filtered rows, as they are not needed in the calculation

Go back to the Location column, select the only option remained > OK.

Then, under the price column, calculate the total by entering the sum formula:

Did this answer your question?