•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#google sheets
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#Google Sheets
#conditional sum
#finanzas
#income
#expense
#month filter
#current month
#selected months
#amount
#full year
#formula
#sum