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

I need to sum all of the cells to the right of a dropdown category anywhere on the page

Good 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]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#AI formula generation techniques
#Excel compatibility
#formula generator
#Excel alternatives
#expense
#budgeting
#dropdown
#SUMIF
#expenses
#sheet
#category
#costs
#totals
#month
#formula