•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula for adding/subtracting on a conditional value.
Our take
To effectively manage your consolidated savings while tracking individual contributions, you can use conditional formulas in your spreadsheet. By summing all inputs for each person and subtracting their outputs, you can easily determine the final balance for both you and your partner. This approach will help you visualize your financial contributions without merging your finances. Don’t worry if creating these functions seems challenging; with a few guided steps, you’ll be able to set up a clear and functional tracking system that meets your needs.
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
Sorry if this doesn't make sense!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to sum all cells in column B where column A in the same row contains a specific string of text?I have a spreadsheet with names in column A and numerical responses in columns B, C, etc. I want to make it so that if, in a given row, column A contains a specific name (say, "Bob"), then the numerical value in column B in that same row will be added. Basically, I want the sum of all the rows in column b for which column a contains "Bob". I can't just sort by column a because sometimes it will contain multiple names per cell (ie Susan, Bob), and I need the equivalent numerical value to be added to both Bob and Susan's total. I've tried google searching this but I can't figure out how to specify same row but different column. I know I could probably do this with what I know already using just like... a lengthy chain of conditionals, but last time I tried that I ended up with an excel file that crashes my computer every time I try to open it, so I was hoping there's a better option. This is Version 16.85 on a Mac btw. submitted by /u/Odd_Nectarine6622 [link] [comments]
- Sum of a range based on 2 different criteria?Hello, I'm working on a document which is a holiday funds to keep track of individual person's remaining balance to pay. I want to use a formula to automatically calculate the sum of a range of cells which lie against a certain year under a person's name. Below as an example: https://preview.redd.it/1p19n1o8qrxg1.png?width=991&format=png&auto=webp&s=2e67c0337da92ae1feffe43fc2c7fbaba237d672 As above, I want to look up Name 1 in 1:1, look up Year 1 in A:A and then return the sum of those numbers in that Year 1 range to give me my final result. Is this possible? I've tried all sorts of SUM, SUMIF, SUMIFS, XLOOKUP and combinations but can't seem to get it to work. I also don't want to have to manually select the cells for year SUM as this is constantly updating and want it to be automated. Thank you! submitted by /u/celestialspace [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- Is there a way to Sumifs up to a certain column with multiple criteria?Hi everyone, I’m looking for a formula to sum all of the columns starting from a particular column up to a particular column. How do I best do that? On the data tab, Row 1 I have the following columns: A1 = date B1 = serial number C1 = customer name D1 = date 1, with the data being $ E1 = date 2, with the data being $ F1 = date 3, with the data being $ In a separate tab I have the same thing mirroring the data tab, but without the $, for the calculation what I intend to do is on E2, I want to say if $A2 = E$ 1, then sum all of D up to E column on the data tab provided that the value on B column of the data tab match B2 of the calc tab, and C column of the data tab match C2 of the calc tab. For F2, it would be the same thing, but sum column D up to column F instead of column E. I hope it makes sense. Thanks for your help! submitted by /u/botng [link] [comments]
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