Sum Formula
Hey Everyone! So Im working on a budget for myself in excell and have a table with all my expenses, I want to try and find the totals of specific items in my budget, for example i have categories of spending like transportation, takeout, groceries, etc. but i have to wait until the end of each month to add up the totals for each specific reason of purchase because the way i have my table set up is in order of date, and i dont want to have to rearrange it alphabetical for reason of purchase and re sum each thing up with new purchases every time.
is there anyway to have the sum function find specific words in columns and add up those totals? instead of cell numbers? my cell numbers change around and aren't all in alphabetical order all the time since im constantly adding new purchases
Thanks yal!