iWork Numbers - Formula with Category

[MrCheeto]

I have a list of expenses and there are columns such as "Description, Cost" the usual, but I also made one named "Type" that is populated with either "Business, Personal," or "Fixed Expenditures".

I would like, then, to make another table that links to the first with three rows. Each one adds the total cost of Business, Personal, and Fixed Expenditures. How can I accomplish this?

I want to divide the expenses into expenses types and create a sum for each type.
Basically, it categorizes the expenses and puts them in three different totals: one for each "Type" of expense.

 

[deadwulfe]

Use the SUMIF() function. It will search through the column you choose (Type) for your criteria (Business, Personal, Fixed) and sum the corresponding values, in the column you choose, for the rows that match your criteria.

there's also SUMIFS() if you want to test multiple criteria.

 

[MrCheeto]

Perfect!!!

Oh thank you thank you!!

 

[MrCheeto]

Wow, that could not have been much simpler.

Finally, I'd like to easily fill in each cell under "type" as I go. Considering they are all one of only six possible Types, I tried the Pop-Up Menu. This serves the purpose, however I need a faster way to populate these fields, such as typing "Bus" and Auto-Completion extrapolating "Business" from the text I typed and then populating the cell with "Business".