•1 min read•from 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
Our take
Good morning! It sounds like you're on the right track with your expense budgeting sheet. To sum all the expenses corresponding to each dropdown category across multiple monthly sections, using the SUMIF formula is indeed a great choice. This formula will allow you to specify the criteria for summing expenses based on the selected category. By setting it up correctly, you can efficiently total the expenses for each category, regardless of where they appear in your monthly layout. Let’s explore how to implement this effectively.
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...
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- Dynamic formula to change calculation based on a dropdown (Hourly vs Daily vs Weekly vs Monthly)I am trying to modify my childcare tracker with a dynamic formula that tracks the cost ($B$1250) per Hour, Day, Week, or Month from a dropdown menu in cell $C$1249. Currently the rows 1255 and 1263 (plus many more) contain formulas such as =SUM(D1253:D1254)*$B$1250. In this hourly pay scale, I just put the number of hours I need for each day, but of course that would change based on pay type. Is there a dynamic SWITCH or IFS formula I can use in those rows, or am I just nuking things? I know I could also add more rows Hourly, Daily, Weekly, Monthly rows and just sum them, but I figured that would become an even more excessive eyesore. submitted by /u/Sardawg1 [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]
- Formula works in most of the cells ant not othersI downloaded a budget excel that was basicly what i was looking for. I coped it 13 times in the work sheet one for each month and 1 for a yearly total. The yearly one is running a current total for the year for what was done so far. My issue is that most of the cells this will work in but there is one section it will not do a running total for unless i have an amount in every cell for the 12 months. Any ideas what could be the issue submitted by /u/cbeard0245 [link] [comments]
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