Hi! This is my first time posting -- be patient with me! 
I've tried to figure this out on my own and have done searches but can't seem to find what I'm looking for. I'm sure this is relatively simple and I'm embarrassed that I can't figure it out. Here goes...
Basically, I want my budget to automatically add up how much I am spending in each category so I can see where my money is going. I've been doing it manually for a long time but it would be great if I could use a formula to do the work for me.
For example, in one row, I will have the store ('Publix'), then the category ('groceries'), then the amount ('$50'). And so on and so forth with all of my spending for the month.
How can I have Excel automatically add together all of the items that are in the same category? All categories will be in the same column of a table, with corresponding amounts in the adjacent cells.
Thanks in advance for your help -- I really appreciate it!
I've tried to figure this out on my own and have done searches but can't seem to find what I'm looking for. I'm sure this is relatively simple and I'm embarrassed that I can't figure it out. Here goes...Basically, I want my budget to automatically add up how much I am spending in each category so I can see where my money is going. I've been doing it manually for a long time but it would be great if I could use a formula to do the work for me.
For example, in one row, I will have the store ('Publix'), then the category ('groceries'), then the amount ('$50'). And so on and so forth with all of my spending for the month.
How can I have Excel automatically add together all of the items that are in the same category? All categories will be in the same column of a table, with corresponding amounts in the adjacent cells.
Thanks in advance for your help -- I really appreciate it!
