•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional sum by type and month filters in Google Sheets
Our take
Managing finances can be challenging, especially when trying to track income and expenses effectively. In Google Sheets, you can harness the power of conditional sums to streamline your financial overview. By using specific formulas, you can easily calculate total income and expenses based on selected months, or even view results for the current month and full year. Ready to transform your financial tracking? Let’s explore the best way to structure your formulas to achieve clear insights and gain control over your financial data.
I'm using Google Sheets and I have a sheet with a simple table called finanzas.
I want D3 to show the sum of the amount if its type is income, and E3 to show the sum if its type is expense.
This should work both when there is no month filter applied and when I select one or multiple months.
I'm trying to manage my finances and I want to be able to see results for:
- current month
- selected months
- full year
Could someone guide me with the correct formula or best way to structure this?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Sumifs formula based on rows of datesI am looking for help with a formula for my monthly budget. Below is a screenshot to help explain what I'm looking for. I have columns for the type of expense (column A), category (column B) and details per category (column C). I for each of those I have column J, which is the single amount to pay per bill and columns K and L for the frequency per year and the 1st date. From this, I created a sequence formula to get the list of dates for the year, which is listed on the row along the next few columns. Here's where things get dicey for me. I want to sumifs all the car payments for the month of Feb. But I don't know how to combine that with searching the row for the #of feb dates and then multiplying that by the single payment, per row, that will then get sumif-ed into a single amount for Feb Car. Let me know if this is even possible or if this is too big a problem and I'll have to reorganize my budget. https://preview.redd.it/2lwkwxdfx9lg1.png?width=1873&format=png&auto=webp&s=63dacd71676ee443972a2e70805c73529069a967 submitted by /u/ApprehensiveDuck4379 [link] [comments]
- I need to sum all of the cells to the right of a dropdown category anywhere on the pageGood morning, I am creating an expense budgeting sheet where the user can select an expense category in a dropdown, and to the right of the columns with the dropdown option, there is a column for the expense costs. I have multiple sections for each month, so twelve columns with dropdown option and twelve columns with the costs (which are to the right of the dropdowns) What I want to do is have a section that sums up the category expenses throughout the year. So even though expenses can appear in any month section, I want them to be totaled in a different section. I assume it would be a SUMIF formula... submitted by /u/Disastrous-Piano-468 [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]