1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Trying to use sum code but I am failing

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

submitted by /u/WarthogSlight6337
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#no-code spreadsheet solutions
#Excel compatibility
#row zero
#financial modeling with spreadsheets
#Excel alternatives
#inventory
#Calculate
#FINAL SALE PRICE
#Money
#Purchased price
#add up
#price
#sum code
#tied up
#pictures
#rows