Quote:
|
Originally Posted by szango420
Im making a balance sheet for expenses. ive attached it so you can see what im trying to accomplish. I have droplists under my expense column. the drop down list draws from the F column. i want the G column to sum the individual catagories from the entire D column but only that catagory. i hope that makes sense.. i have no idea how to accomplish this. any help would be great.. thank you!
http://www.szango.com/expenses.zip |
The way you want to do this is awkward as I presume your C column will be your categories and the D column is the figure?
You need to use formulas to do this automatically however if you keep adding info to the C column the formula wil not work. I will set up a worksheet of how I think you want it to work and send it to you. I am MOUS certified