Forum Discussion
sub boxes
i use excel to keep track of my bills and what i spend. im trying to figure out how to get all my items i spend for a category in a drop down sub folder where i can enter each item and what i spent i...
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
I can only repeat myself again.
Add a file (without sensitive data) and explain your plans on the basis of this file. Please no photos, especially with Excel these do not help in most cases, sometimes even the opposite.
Let us know which version of Excel and which operating system you have.
You probably don't need a dropdown menu, rather see a pivot table that suits your project.
But first, please read the above information.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Add a file (without sensitive data) and explain your plans on the basis of this file. Please no photos, especially with Excel these do not help in most cases, sometimes even the opposite.
Let us know which version of Excel and which operating system you have.
You probably don't need a dropdown menu, rather see a pivot table that suits your project.
But first, please read the above information.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
NikolinoDE ok added the excel file