Hi, I have a table with all the transactions I have made throughout the month. The table has 3 columns, "Category", "Amount", and "Description". What I am interested in doing is creating a second table that has columns "Categories" and "total". I want the total column to sum up all the totals of a certain category. Sometimes the row order of the first table changes after adding new data because I like to have it in alphabetical order. Because of this I can't use =sum(cell1:cell3). Does anybody know of an alternative so that rows of the same category can all be summed together?
Bookmarks