Hello. I am trying to calculate the current value of my unsold stock. Each item has a 'price' and 'resell' value. If the 'resell' value is blank, it means the item has not yet been sold.
https://docs.google.com/spreadsheets...it?usp=sharing
You can see across my 2 sheets, 4 items have not been sold:
Scarf, T-Shirt, Table and Curtain.
example.png
The total value of these 4 unsold items is £753.00, and this is the value I want to display as the 'Unsold Stock Value'.
I know how to calculate the values of a column by using
And I assume this should be wrapped in a sumif statement.
I also know I can reference each individual price cell by using something like
I'm just not sure how to combine the two functions to achieve the desired result.
Thank you.
Bookmarks