Forum Discussion
sub boxes
adversi yes something like that. i want the highlighted area to sum up what I put into the drop down. so this is the amount I spend on gas. In the drop down I want to see where I spent the money for gas and the total. so I would input shell in one cell then the total in the next cell and so on for the next few stations I go to as shown below in example 1. the sum of the amounts would then be displayed in example 2 in the highlighted area. hopefully this helps
example 1
example 2
Thanks for clarifying. You will need to create a SUMIF relation.
For example 1, Column C or the last column of your expenses should have the dropdown option.
You can do this by:
1. Select all the cells in Column C that you need and go to the Data section of the ribbon and select Data Validation.
2. From there you change the Allow: option to List and under Source: you can select all the options you have listed under the 15th of the month column in your Example 2 screenshot.
3. Under your Actual Cost column in Example 2, your SUMIF formula should be like this (used placeholders to give a better detail of what the formula needs):
More information can be read https://www.excel-easy.com/examples/sumif.html.
=SUMIF(Example1ColumnC,Example2B38,Example1ColumnB)
adversi ok that isnt what im lookng for. i want a drop down box that i can fill out like example 1 and have the total from that populate in the cell of example 2. from what i can see the solution you provided doesnt do that
What needs to be created is a standardized category list that can be summed dynamically. See the example below following the steps from the previous response.
Can you confirm if this is what you're looking for or is there an element missing?
adversi no this is not what i want either. close tho. i want the gas trips hidden in a drop down that i can click on. so in the cell that says gas there would be a + sign in one of the corners or some kind of button that would expand a window where i could input the fillups and the charge then have it sum it up and display the total in the gas cell