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

Formula for adding/subtracting on a conditional value.

Hi, I'm setting up a spreadsheet for my partner and I as we are consolidating our savings but want to keep track on who has what amount of money. (We are consolidating for interest reasons, not for joint finanical reasons)

I have created the spreadsheet below, and basically what I want is:

  • sum all [person b + input]
  • subtract all [person b + output] from [sum input] to give final value of money
  • ^^ and again for Person A

I'm not good with creating my own excel functions at all, so I'm really struggling

https://preview.redd.it/h858fn3cgfwg1.png?width=717&format=png&auto=webp&s=35036974049799ebec79d5daf9affc08ae8a60d9

Sorry if this doesn't make sense!

submitted by /u/mudkip0099
[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
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#Excel alternatives
#spreadsheet API integration
#rows.com
#financial modeling with spreadsheets
#AI formula generation techniques
#formula generator