Forum Discussion
sub boxes
I'm a little confused - do you mean creating a dropdown of main expense categories and having the figures automatically sum by category?:
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)
