Aggregate totals for columns by category vs budget

Hi,

I'm looking to build a really simple budget management spreadsheet. I've attached an image of how I'd see the finished article look. I'd like columns with categories and prices and then on the right hand side a simple summary of each of the categories, the original budget and then to colour code if I am over or under budget for that category.

- I can manage setting up the categories via Data Validation
- I can get the dynamic summary of categories using UNIQUE (I think!)
- However I cannot get all of the totals for each category and then the status, ie +5 or -3 with colour red or green.

Any help appreciated, thanks
Paul

excel.png

Have a look at the attached. Is this of any use to you?

A simple SUMIF and some Conditional Formatting and job done.

Let me know if you need any of it explaining.

BSB.

1) Auto Calculation may be turned off in my example spreadsheet. Switch that back on and it should calculate changes live.
2) In your original post you said you had a method for doing this, so I didn't put the effort in. If that's not the case then you'll have to leave it with me for a while as I'm about to leave work and wont have access to Excel until I get home in a couple of hours.
3) No, that will make no difference. I didn't do that as you said you already had that sorted.

Re: 1) Auto Calculation is set to Automatic in the spreadsheet
Re:2&3) No worries

Thanks for your help,
Paul