In the attached Excel spreadsheet I have made columns E through Y which are categories of expenditures like food, restaurants, tax deduction etc. I have put a 1 in the column for amounts in column E that correspond to each category. I want to get a total at the bottom each category column of the expenditures for that category.
I could sort by each category then cut the amounts for that category and paste them in that category column but that would be tedious. I am hoping there is a formula I could use to get what I am looking for.