trying to add items from a list

[ahitch]

I have created a spreadsheet to keep track of a budget by different categories. Basically each row has a date, vendor, purchase amount, and category. On the top of the spreadsheet I have a list of about 10 different categories.

I created a drop down box (or list) for each category in every row. Basically I'm trying to get the total for each category selected from the drop down box to display in a cell on the top of the spreadsheet. Is this possible?

[Palmetto]

IMO, it is best to use a Pivot Table, which will allow you to set the selection field you are now using as the Page Field (which you may use as a report filter).

However, take a look at using the SUMIF or SUMIFS function. It will let you select a range against which to apply a criteria ( your drop down selection) and then sum cells in an adjacent range where the condtions are met.