Trying to use sum code but I am failing

unsolved

I am trying to Calculate how much Money i have tied up in inventory. See below for pictures.

In my head i want the code to read IF there is no FINAL SALE PRICE then add up the Purchased price for each row that this is true with.

https://preview.redd.it/vi7997xvogng1.png?width=493&format=png&auto=webp&s=afee874b5ea60174bc7139b1722ae62ddf082c02

https://preview.redd.it/pw7v4ll3pgng1.png?width=1728&format=png&auto=webp&s=679153f5abba42cb871e02b74c3bbc815bd01a27

Posted Mar 6, 2026, 5:44 PM UTC · locked

58
Loading comments…