<prompt> Human: Hi everyone, Ive been working on an Excel workbook that keeps track of all my transactions I make with my various debit and credit cards. I input the date, description, category, amount, and end balance of the transaction. What I would like to do is filter through my various transactions, add up all the expenses spent on category x, and output that value to a cell so that I can get a better idea of what my money is being spent on. Is this possible? Any help with this problem is much appreciated. EDIT: I ended up going with ucaringexecutive s suggestion. Pivot tables rule! Thanks everyone.  <response>: The SUMIF function will do this.The function takes 3 arguments: You give the range that contains your categories, then the category you are looking to sum, then you give the range of cells containing your transaction amounts. 